Transform "," to ";" before import

  • 18Views
  • Last Post 20 September 2021
0
votes
iEARN Technology posted this 17 September 2021

Hi, I was unable to find support documentation on this so wondering if the feature exists. 

I am trying to map multi-select value separated via "," in the source file to multi-select filed in Salesforce. Is there a way we can set up filed mapping to transform "," to ";" before import so the file doesn't error out?

Example: 
IT, IPF, STAFF4 > should be formatted as IT; IPF; STAFF4


Please let me know if you have any questions & thanks much!
Iva

0
votes
Mariia Zaharova posted this 20 September 2021

Hello Iva,

 

Thank you for contacting Skyvia Support. You can try using Expression mapping for this case. For example:

replace(source_field,',',';')  

 

Please check 

https://docs.skyvia.com/data-integration/common-package-features/mapping/expression-mapping.html

https://docs.skyvia.com/expression-syntax/

 

Please tell us if this helps.

 

Best regards,

Mariia

Close