JavierMartinez
6 years agoQrew Cadet
Extract characters
I am trying to extract the first two or three characters before "WN" in a text field. Left(Trim([Incident Number]),"WN") works until you have something that has another "N" or "W". Example text is: DTWWN11111111 or DEWNWN000000000. Text can also be CCWN001111111.
I know this might be simple, but I can't figure it out. Any help will be greatly appreciated.
I know this might be simple, but I can't figure it out. Any help will be greatly appreciated.