Add single quotes in comma separated string

Question

Hello,
I have a scenario where the location name will come in 2 different scenarios from an API as mentioned below.

LOC1
LOC1, LOC2, LOC3

The expected output should be

‘LOC1’
‘LOC1’, ‘LOC2’, ‘LOC3’

I tried using the split and replace function but in vain. Appreciate any help provided here
Thanks
Aravind N

jcornelius · Answer

‘"+ $yourfield.split(’,‘).join(’','‘) +"’

arvindnsn · Answer

This worked perfect. I was trying something with the map function but was missing something. Thanks for the solution.

arvindnsn · Answer

Yes, Correct. Thank you for the suggestion and input!!

darshthakkar · Answer

Hi @arvindnsn,
Did you try using the basic concatenation function?

darshthakkar · Answer

I used a simple conditional statement in my mapper like below:
$field002!=""?" ' "+$field002+ " ' ":""

You might have to tweak a bit if you’re expecting multiple values in your second stream.

Forum Discussion