Dear All,
I have a problem with a PIPE "|" delimited flat file. I have a column "Description" in which we get a string in which we have PIPE "|" as data. How we can skip this and load it as a data into the column Description. Please help.
Regards,
kranthi.
How to Skip PIPE(comes as data) in PIPE Delimited Flat file?
Moderator: DosItHelp
Re: How to Skip PIPE(comes as data) in PIPE Delimited Flat f
Please provide an example of your data.
Re: How to Skip PIPE(comes as data) in PIPE Delimited Flat f
You problem is common to CSV files. Originally, the term CSV was restricted to Comma Separated Values. But common usage has expanded the meaning to include nearly any human readable text format with delimited values.
Your specific problem involves a "CSV" file that uses | as the delimiter (instead of a comma)
I have posted a description of difficulties with parsing CSV files, along with a robust and general solution at Safely parse nearly any CSV with parseCSV.bat. Read up on the issues, and see if you can't adapt one of my posted examples to suit your needs. You will need to make sure that you quote any values that contain the delimiter as a literal character.
You can use the "/I:|" option to specify that a pipe is your delimiter.
If you can't figure it out, then you can post an exerpt of an example file that demonstrates your issue(s).
Dave Benham
Your specific problem involves a "CSV" file that uses | as the delimiter (instead of a comma)
I have posted a description of difficulties with parsing CSV files, along with a robust and general solution at Safely parse nearly any CSV with parseCSV.bat. Read up on the issues, and see if you can't adapt one of my posted examples to suit your needs. You will need to make sure that you quote any values that contain the delimiter as a literal character.
You can use the "/I:|" option to specify that a pipe is your delimiter.
If you can't figure it out, then you can post an exerpt of an example file that demonstrates your issue(s).
Dave Benham