rszabo
Novice

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

0 Kudos
Reply
1 Reply
emha
Collaborator

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

Reply