topic Re: CSV file read in Application Development and Automation Discussions

CSV file read

Former Member — Thu, 28 May 2009 16:21:44 GMT

Is there a standard FM which handles csv file read? I am currently using a 'split at' to separate values but this fails when some strings ( within quotes) have commas.

Eg:

333,khdfs, "Company name", 87348, " Name1, Name2"

In this scenerio, the last field in quotes gets split into 2. I cannot handle this in the progrm because the last field does not always have a comma split. Any suggestions?

Re: CSV file read

former_member194669 — Thu, 28 May 2009 16:38:24 GMT

I think we don't have any easy way to do this.

My suggestion will be first search the string for starting " and ending " (offset) and then replace the , (in between 2 ") with some other symbol say # something like then go for split.

a®

Re: CSV file read

Former Member — Thu, 28 May 2009 16:38:44 GMT

Hi Suker ,

First you remove all the Quotes , then split into coma (,).

I mean to say --

REPLACE   ALL   OCCURRENCES OF '"'  IN <string_name> WITH SPACE.

Now split the string at the coma - -

SPLIT  AT  ....

Regards

Pinaki

Re: CSV file read

Former Member — Fri, 29 May 2009 10:04:50 GMT

thats a good approach, probably the only approach. Do u have any code with u using offsets?

Pinaki, ur suggestion wont work

Re: CSV file read

Former Member — Fri, 29 May 2009 10:13:29 GMT

Dear ,

I think you should save your file in excel with csv format and then upload this file with FM "GUI_UPLOAD'.

Regards,

Vijay

Re: CSV file read

Former Member — Fri, 29 May 2009 10:17:46 GMT

Hi,

use this FM

TEXT_CONVERT_TEX_TO_SAP

In the parameter i_field_seperator pass ",".

Regards,

Manish

Re: CSV file read

Former Member — Fri, 15 Feb 2013 16:09:51 GMT

Rahul - I have same situation. I have a comma separated CSV file which has address fields with embedded commas in them.

Can you tell me exactly how this has been solved.

Many Thanks.