Comma Delimited - MDM Import Server

[Former Member]

when processing a comma delimited file using Import Server, the data contains commas but enclosed within double quotes ( "test, test"). can Import Server recognize the double quotes and not split the data into multiple fields because of the comma?

regards,

Jarred Alford

[KlausDavid]

If you're using CSV-format, each delimiter sign will also interpreted as a delimiter, putting something in "" doesn't help here. Therefore you've to be very cautious and make sure, these chars are really only used as a delimiter, otherwise your content gets mixed up totally. You can see this pretty good, when calling Import Manager with such a file. in the preview you can see, what the system did with your files.

Best would probably be to choose a different delimiter.

Regards Klaus

[Former Member]

Hi Klaus,

I am using an ODBC (MS Text Driver) in Import Manager and the import executes successfully. i raised this question because of the successful execution using Import Manager but not being succesful with Import Server. Any thoughts? Could this be a "bug" for SAP?

regards,

Jarred