Site column field value cleanup

Discussion created by rszabo on Apr 14, 2016

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