How to import data via Integration Center that has commas

[Adam_S]

Hi - 

I am trying to update Requisition data via Integration Center but am running into an issue with commas in my CSV file. When I upload a sample CSV file to the IC job, the data 'breaks' where there is a comma in the values and everything shifts to a new column. The data in my CSV file does have double quotes around the values that have commas, but IC doesn't seem to respect these double quote and 'breaks' the data wherever a comma is present. Is it possible to have valid commas in the data of your input file? If so, how can I get this to work?

Thanks

[Adam_S · Accepted solution]

I spoke with SAP support (via Expert Chat) about this and there was not a straightforward solution to allow an Integration Center job to accept values that have commas.

As a workaround, we put different values in the columns that contained columns and then added a Value Lookup Table to the IC job to translate to the appropriate value - with commas...  This worked as expected once it was all set up. Just took some additional time to set up the lookup tables and adjust the import file.

[matheustrevis · Accepted solution]

Hello, could you please explain how you did this lookup to make it work? I'm having the same issue. Thank you in advance.