Volkmaniac
Technical User
I was able to grab a number off the terminal screen and place it into Excel using the following:
proc main
set aspect rgetchar 13
transmit "GET-LIST JV_TODAY^M"
rget sLine
set aspect rgetchar 32 STRIP
rget sLinea
strreplace sLinea "`r" ""
strreplace sLinea "`n" ""
strtonum sLinea Number
ExcelCheck()
RunDDE()
CleanUp()
Email_5()
endproc
I didn't have as much luck trying to grab these numbers and save them into strings:
TEAMNAME.... CLIENT#... CNT. PN-ASSIGN. TOT COLLECTED
CAP1SHZ 13 29796.55
CAP1SLZ 4 2584.55
CAP1SPZ 1 1086.58
CAP1SSZ 3 6579.36
A:
All I need is the numbers. I've tried stripping 32 and using ASCII 13 but they didn't give me the numbers separately.
proc main
set aspect rgetchar 13
transmit "GET-LIST JV_TODAY^M"
rget sLine
set aspect rgetchar 32 STRIP
rget sLinea
strreplace sLinea "`r" ""
strreplace sLinea "`n" ""
strtonum sLinea Number
ExcelCheck()
RunDDE()
CleanUp()
Email_5()
endproc
I didn't have as much luck trying to grab these numbers and save them into strings:
TEAMNAME.... CLIENT#... CNT. PN-ASSIGN. TOT COLLECTED
CAP1SHZ 13 29796.55
CAP1SLZ 4 2584.55
CAP1SPZ 1 1086.58
CAP1SSZ 3 6579.36
A:
All I need is the numbers. I've tried stripping 32 and using ASCII 13 but they didn't give me the numbers separately.