Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

data with "," overflows to the next field when importing data with DTW

Dear all,

When I tried to import data with DTW, for the data that includes ",", the data after "," all jumps into the next field after import.

E.g. Column A(memo): bank, United state

Column B(project code): blank

Result in SBO: Memo field : bank

Project code: United state

I have tried 2 ways.

1. Save the file as csv, and adding double quote(") at the beginning and ending of the data. However, it didn't work. It didn't work with single quote as well.

2. Save the file as txt, without amending the data at all.

It worked, however, in SBO, double quote is auto added, it becomes "bank, United state".

Please kindly advise how to handle such case.

Thank you.

Regards,

Julie

Former Member
Former Member replied

Hi Julie,

After you save to Text format, you could open the text file by text editor such as Notepad. Using replace function to replace all " with blank. Save the file with same name. This will ensure no "" after DTW.

Thanks,

Gordon

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question