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

[darshthakkar]

Hi @arvindnsn,

Did you try using the basic concatenation function?

[darshthakkar]

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.

[Abhishek_Soni37 · Accepted solution]

@arvindnsn

With this expression, you should be able to make it work.

pipeline:
Test_Expression_2023_06_17 (1).slp (3.5 KB)

Let me know if that helps.
🙂

Cheers,

[arvindnsn]

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