Technical support and scripting issues
Moderators: Dorian (MJT support), JRL
-
UncleBen
- Newbie
- Posts: 6
- Joined: Thu Oct 02, 2014 12:22 pm
Post
by UncleBen » Mon Dec 22, 2014 8:11 am
Hello!
I've got an issue.
Code: Select all
ReadFile>%find_Var_1%,vData
Separate>vData,lf,vLine
let>n=1
Repeat>n
Let>text=vLine_%n%
StringReplace>%text%,","",text
StringReplace>%text%,crlf,lf,text
VBEval>LCase("%text%"),text <--- after this line Macro Scheduler is showing that error.
Position>%find_Var_2%,%text%,0,nPos,TRUE
[...]
Until>n,vLine_Count
any ideas?
-
Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
-
Contact:
Post
by Marcus Tettmar » Mon Dec 22, 2014 10:30 am
It's probably the line feeds. This line won't help:
StringReplace>%text%,crlf,lf,text
The LF will confuse VBScript because the line wrap will unterminate the string.
Replace with VBScript's line feed tokens instead:
StringReplace>text,CRLF," & vbCRLF & ",text
Also note uppercase CRLF.