Showing results for 
Search instead for 
Did you mean: 
Nintex Newbie

Site column field value cleanup

I had a site column to create cross-site lookup to a list in which I stored important values.

After I saved a record with a selected value, in the list it looked fine, but the actual value was something like this: 1;#Value

With a replace, you can get rid of the unneccessary parts.

replace({YOURVALUE},"[0-9]*;#","") or fn-replace...

Labels: (2)
0 Kudos
1 Reply
Automation Master
Automation Master

Re: Site column field value cleanup

for that purpose there is parseLookup runtime function

with it you can even define whether you want to parse out a key or a value

parseLookup([array or single lookup value], [optional bool showText])