topic Key Field - Maniulating a text string in QlikView

Key Field - Maniulating a text string

stuwannop — Tue, 02 Oct 2012 12:20:48 GMT

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

Re: Key Field - Maniulating a text string

swuehl — Tue, 02 Oct 2012 12:24:49 GMT

If you want to essentially keep the numeric letters, try

keepchar(FIELD, '0123456789')

Re: Key Field - Maniulating a text string

stuwannop — Tue, 02 Oct 2012 12:30:13 GMT

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

Thanks a million I'll give it a try.

Stu