This content has been marked as final. Show 4 replies
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.
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!