Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QUESTION WITH RGETS

Status
Not open for further replies.

Volkmaniac

Technical User
Mar 19, 2003
104
0
0
US
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.





 
When you say you couldn't get the numbers separately, do you mean line from line or, for instance, 13 from 29796.55? Were you able to come up with a string that had the entire line in it at least to start from?


aspect@aspectscripting.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top