Passing comma seperated values in csv schema


I have a text schema activity using a comma in the field separator which is causing a field with Last Name, First Name to divide into 2 columns.

What is the correct method to apply for the field separator to column Direct Supervisor keep the value Last Name, First Name as 1 column?




In your mapper try using this function.
concat('"',xpath of the Direct Supervisor field' from source,'"' )

Concatenate the value with double quotes. In other words put a double quote around
the source value using the concat function.


Have more questions? Submit a request


Article is closed for comments.