Substring extraction from each line of CSV file

  • This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
Mar 21, 2011
1
0
#1
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.
 
#2
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
 
#3
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