Okay so if you want to remove leading zeros from a field value it's fairly straightforward if you search the forums there are a couple of solutions available such as-
replace(ltrim(replace(MyField,'0',' ')),' ','0')
but say you want to remove leading zeros numbers in a comma separated list.
Would be transformed into
The reason I'm asking is that I have a qlikview document that allows a user to paste comma separated lists into a variable input box and it searches normalised (read leading zeros removed) Id field by producing a string like (123456789|0123456789|0000444444). I need to get it to search for (123456789|123456789|444444) instead. Is there an easy way of achieving this?