SAP – Create CSV from Text format

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.

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • mshen
    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
    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
    …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
    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

    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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following