Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Read CSV file with quotes

Former Member

‎2010 Apr 29 8:53 AM

0 Likes
457

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.

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.

Reply
1 REPLY 1
Read only

SuhaSaha
Product and Topic Expert
Product and Topic Expert

‎2010 Apr 29 9:01 AM

0 Likes
397

> 

> 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 ?