Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stuwannop
Partner - Creator III
Partner - Creator III

Key Field - Maniulating a text string

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

If you want to essentially keep the numeric letters, try

keepchar(FIELD, '0123456789')

View solution in original post

2 Replies
swuehl
MVP
MVP

If you want to essentially keep the numeric letters, try

keepchar(FIELD, '0123456789')

stuwannop
Partner - Creator III
Partner - Creator III
Author

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

Thanks a million I'll give it a try.

Stu