cancel
Showing results for 
Search instead for 
Did you mean: 

How to import data via Integration Center that has commas

Adam_S
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Adam_S
Explorer
0 Kudos

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.

Answers (0)