Cleaning Dirty Data String, remove last 2 Characters and Numbers

Peter_Brunner — Mon, 07 Apr 2014 12:24:39 GMT

Hi All,

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

regards Peter

topic Cleaning Dirty Data String, remove last 2 Characters and Numbers in QlikView