Integration Center - Replace comma by ","

[sureshsanka]

We are generating csv file using integration center and some fields have comma in their values. We have to replace comma in the field values by ",".

Eg: Address Value: 123, Baker Street

Need to replace this value as 123 "," Baker Street (or) "123, Baker Street"

[Anastasia1]

Hi!

Look to this article: https://blogs.sap.com/2018/07/03/successfactors-goodbye-provisioning-jobs-part-1-using-integration-c... (point 5). You can create calculated fields with quotes.

Or, you can try to use these formats:

True CSV: CSV file type that accommodates special characters such as carriage returns, new lines, double quotes, commas.

Simple Delimited: uses delimited formatting that uses different characters to separate data values such as commas, tabs, and colons.

Regards,

Anastasia