Read CSV file with quotes

Former Member — Thu, 29 Apr 2010 07:53:20 GMT

Hi all,

I have a CSV file that is like

1,Peter,"San Fransico

USA"

2,David,"USA"

There should be only 3 columns in the csv file. However if we use the standard function from SAP, it will read 3 rows.

Is there anyway to treat the fields in the quote as one column?

Thank you.

Re: Read CSV file with quotes

SuhaSaha — Thu, 29 Apr 2010 08:01:33 GMT


> I have a CSV file that is like
> 
> 1,Peter,"San Fransico 
> USA"
> 2,David,"USA"
> 
> There should be only 3 columns in the csv file. However if we use the standard function from SAP, it will read 3 rows.
> 
> Is there anyway to treat the fields in the quote as one column?

Why is the CSV file maintained like this in first place? Is it done by error and can this be modified ?

topic Re: Read CSV file with quotes in Application Development and Automation Discussions

Read CSV file with quotes

Re: Read CSV file with quotes