4 Replies Latest reply: Feb 12, 2018 1:50 PM by Krzysztof Wroclawski RSS

    Fixing field during LOAD XXXX Name ***NOT***

    Krzysztof Wroclawski

      Hi Experts,

       

      My regular format of the field is 123456 Big Customer Number One I checked Community forum to find the way to remove numbers. Solution which works for me is:

       

      right ("Customer", len ("Customer"]) - 7) AS NameOnly,

       

      However, I have another problem. Some of the Customer's names have ***NOT*** at the end. I would like to exclude number and ***NOT*** part from customer's name.

       

      Summary:

       

      Field   123456 The Biggest Corporation INC. should give The Biggest Corporation INC.

      Field    654321 The Biggest Corporation INC. ***NOT*** should also give The Biggest Corporation INC.

       

       

       

      Thank you in advance for all tips!

      Kris