Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Cleaning Dirty Data String, remove last 2 Characters and Numbers

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

SubStripCode.png

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

Suburb.png

Hope it helps

regards Peter

0 Replies