Substring extraction from each line of CSV file

R

rv_driver

Mar 21, 2011
1
0
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.
 
S

Steve Fabian

May 20, 2008
3,515
4
Elkridge, MD, USA
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
 
C

Charles G

Apr 2, 2011
1,607
15
55
North Carolina, USA
Wouldn't some form of SETDOS /x-12345678 work too?
----- Original Message -----
From: Steve Fabian
To: CSGalloway@nc.rr.com
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
 
You must log in or register to reply here.
Top Bottom