SAP – Create CSV from Text format

8223

70 pts.

Tags:

CSV format

SAP development

SAP Import/Export

I tried to convert the text format to CSV format by USing internal table and the FM isSAP_CONVERT_TO_CSV_FORMAT. But wn i download to CSV format the file contains fields serepared by ';'.So becuse of this Im unable to Up load this file.

Asked: April 2, 2009 4:11 AM Last updated: February 7, 2014 5:29 AM

Answer Wiki

Last updated: April 2, 2009 6:21 AM GMT

mshen27,385 pts.
History
Contributors
- Ordered by most recent
- mshen27,385 pts.

Thanks. We'll let you know when a new response is added.

Do a find and replace all on the file. Replace all “;” with “,”.

No ..we can replace but while uploading from CSV file again we are getting error.

The CSV file now downloading into this manner:
A B C D E
01;10102009;3040490
02 ;10092009;3040494

but it has to be:
A B C
01 10102009 3040490
02 10092009 3040494

Discuss This Question: 5 Replies

mshen Apr 3, 2009 6:40 AM GMT

I don't quite understand anymore. Once you download the file, you can replace ; with , . Then upload the file with no problems. What are your steps and where are you having the problem?

27,385 pointsBadges:

report
JoeA5 Jul 18, 2010 1:27 PM GMT

If you will be performing this procedure often, then I suggest you use a 3rd party data migration software. Check out EzySolutions by Gesix. EzySolutions is a user and process efficiency tool that seamlessly integrates Excel with SAP to download, modify and upload any SAP R/3 data.

30 pointsBadges:

report
TomLiotta Jul 20, 2010 5:14 AM GMT

…integrates Excel with SAP to download, modify and upload any SAP R/3 data. …which is generally a very bad idea and should be avoided at almost all costs. Generally, it should be forbidden by any SAP administrator. Tom

125,585 pointsBadges:

report
Azzouni Jul 20, 2010 1:19 PM GMT

I'm not sure why is this a bad idea Tom. Even if SAP's function module does not work, we can always write a small utility to read the internal table structure and create a simple CSV file.

40 pointsBadges:

report
satyamudam Feb 7, 2014 5:29 AM GMT

Hi to all,

i need to covert the sql files in to .csv file can you people help out of this and i need to any tools available on this please send me a link.

Regards,

satya

10 pointsBadges:

report