FIND IN A STRING

[jumiprado]

Hi,

I have a field that takes names but in some cases the values are

NAME1

NAME2

NAME1&NAME2

NAME3

NAME1&NAME2&NAME3

I need to find from another list the names that are in the example and i have to separate this in differentes columns.

Thanks!

[vishsaggi · Accepted solution]

Can you show an example values of your field.

You can use like Subfield(Yourfieldname, ',') comma here is a delimiter.