Add a prefix or suffix to a list of comma separated values

Question
1

I have a field with multiple comma separated values, like “item1, item2, item3…”.
I need to add to each of these values a prefix or a suffix obtaining a similar result “T_item1, T_item2, T_item3…”. Is it possible with your software solution?
Thanks in advance

2

just simple replace ", " by “, T_”.
This doesn’t add it for the leading first item. For this I would use a new column with the prefix “T_” move it in front of the other column and concat both.

1 Like
3

Thanks a lot, it was easier than I thought :joy:
By the way, what function should I use?

4

image
image1192×83 27.8 KB

Suffix1.transform (3.1 KB)

2 Likes
5

Yes it is and here is the solution.

image
image735×622 78.7 KB

Transform file.
AddSufixorPrefix.transform (6.2 KB)

3 Likes
6

Thanks a lot Olaf! Very simple and effective!

7

I am also stuck on that issue but your knowledge is easy to understand. I hope I will not forget. I appreciate your support.

1 Like