Discussion Board for collaboration related to QlikView App Development.
I thought I would give back some help to maybe help others.
I had Dirty Data in a "Suburb" Field which I need to clean up, I wish to use this Field to match to another Field.
So far I have successfully cleaned off the Posted Code with the PurgeChar() but have been spending a few hours with no success
on stripping last 2 characters "SA" off.
then I worked it out
By Using the Help example of left(Date, 4) where Date = 1997-07-14 returns 1997. I used a variable in place of 4
Fields Left to right with Clean up process
Hope it helps