Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Brunner
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