Cleaning Dirty Data String, remove last 2 Characters and Numbers

[Peter_Brunner]

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