data with "," overflows to the next field when importing data with DTW
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.
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.