text expander.ahk

;*******************************************************
; Want a clear path for learning AutoHotkey; Take a look at our AutoHotkey Udemy courses.  They're structured in a way to make learning AHK EASY
; Right now you can  get a coupon code here: https://the-Automator.com/Learn
;*******************************************************
#SingleInstance,Force
;~ https://autohotkey.com/docs/Scripts.htm#continuation ;scroll down after loading page
;***********Join***Text Expander**************** 

/*
`s Space  `r`n=CR+LF  |=pipe
LTrim: Omits spaces and tabs at the beginning of each line
% (percent sign): Treats percent signs as literal rather than as variable reference
Comments Allows semicolon comments
, (comma): Treats commas as delimiters rather than as literal commas. 
*/
try:="hello world"
Browser_Back::
:o:j1.::
var=
( Join`r Comment Ltrim
---- this is what I need to do to show  on the totals -----
select distinct cm.EMAIL_ADDRESS Email,cm.UPLOADING_COUNTRY  
    from ods.em_camp_global_contact_master cm  ;another comment
    inner join ods_email.sp_engage_all_eventtype_master aa on (cm.EMAIL_ADDRESS=aa.EMAIL_address) ;join on email address
    WHERE  aa.event_timestamp > CURRENT_DATE - INTERVAL '1' MONTH  --Date '2015-06-01' 
)

SendInput, %var%
return

Browser_Forward::Reload