Selection of a single value from a string separated by some delimiter with other values

[anshulsri]

Hi All,

I am working on one requirement where I am getting multiple values in a single cell separated by delimiter. For example in a single cell  we are getting  data as following:

Here we have multiple Project ID separated by semicolon in a single cell. Our requirement is:

when we select on a Project Id only that value should be selected not the whole string. For example we have 5591;5569;5566;5586;5582;5567 and we click on 5591 only it should be selected not the whole string.

Any help is very much appreciated.

Thanks,

Anshul

[Vegar · Accepted solution]

I suggest that you split up the concatenated ProjectID fields into multiple single value fields in your script. To accomplish this you could use the subfield() function.

SubField([Project ID], ';') as [Project ID]

[anshulsri]

Thank You Vegar!!

But I was hoping to achieve it with out the splitting of the field.