Site column field value cleanup

+6

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...

+14

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])

Sign up