Key Field - Maniulating a text string

[stuwannop]

Hi All

I am looking to join two fields together from two tables thus creating a join. My problem is the data is in a different format although data on both sides contains one common string of 6 numbers, which I want to use as my key.

Table A will have data such as CRM678916, 776423NORTH, SOR234445CRM etc.

Table B Will have SORD-678916, SORD-776423, SORD-234445 etc.

Notice the strings of numbers are the same. I need to manipulate in my script both fields so they only display the first six numbers it finds in the string. I can do it in excel but not Qlikview can anyone help?

Thanks

Stuart

[swuehl · Accepted solution]

If you want to essentially keep the numeric letters, try

keepchar(FIELD, '0123456789')

[stuwannop]

Wow didn't think it was that simple - the excel formula wasn't!

Thanks a million I'll give it a try.

Stu