Add single quotes in comma separated string

[arvindnsn]

Hello,

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

1. LOC1
2. LOC1, LOC2, LOC3

The expected output should be

1. ‘LOC1’
2. ‘LOC1’, ‘LOC2’, ‘LOC3’

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

Thanks
Aravind N

[jcornelius]

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

[arvindnsn]

Good to know using the simple join function to achieve the output. Thank you!!

[darshthakkar]

Yes, multiple ways to achieve the desired output. Some cover all use cases and some won’t. If you have an edge case scenario, that will need a custom formula.

[arvindnsn]

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