Substring extraction from each line of CSV file

[rv_driver]

Need a method or new variable to read each line of a csv file that may contain special characters that attempt an operation instead of being stored in the variable LineX or X1.

set LineX=%@LINE[%filename,1]
set X1=%@INSTR[0.20,%LineX]

Will not work without an error: " No closing quote" in some of the lines in the csv file.

 

[Steve Fabian]

From: rv_driver

| Need a method or new variable to read each line of a csv file that
| may contain special characters that attempt an operation instead of
| being stored in the variable LineX or X1.
|
| set LineX=%@LINE[%filename,1]
| set X1=%@INSTR[0.20,%LineX]
|
| Will not work without an error: " No closing quote" in some of the
| lines in the csv file.

Use the function @safeline[] in the plugin safechars.dll from Charles Dye. Same syntax as @LINE.
--
HTH, Steve

 

[Charles G]

Wouldn't some form of SETDOS /x-12345678 work too?
----- Original Message -----
From: Steve Fabian
To: [email protected]
Sent: Thursday, September 15, 2011 04:37 PM
Subject: RE: [Support-t-3215] Substring extraction from each line of CSV file


From: rv_driver

| Need a method or new variable to read each line of a csv file that
| may contain special characters that attempt an operation instead of
| being stored in the variable LineX or X1.
|
| set LineX=%@LINE[%filename,1]
| set X1=%@INSTR[0.20,%LineX]
|
| Will not work without an error: " No closing quote" in some of the
| lines in the csv file.

Use the function @safeline[] in the plugin safechars.dll from Charles Dye. Same syntax as @LINE.
--
HTH, Steve