2 Replies Latest reply: Oct 2, 2012 8:30 AM by stuart wannop RSS

    Key Field - Maniulating a text string

    stuart wannop

      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