โ06-14-2023 02:39 PM
Hello,
I have a scenario where the location name will come in 2 different scenarios from an API as mentioned below.
The expected output should be
I tried using the split and replace function but in vain. Appreciate any help provided here
Thanks
Aravind N
Solved! Go to Solution.
โ06-17-2023 10:57 AM
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,
โ06-19-2023 01:51 PM
โ"+ $yourfield.split(โ,โ).join(โ','โ) +"โ
โ06-23-2023 10:30 AM
Good to know using the simple join function to achieve the output. Thank you!!
โ06-23-2023 10:32 AM
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.
โ06-23-2023 11:18 AM
Yes, Correct. Thank you for the suggestion and input!!