AN~iNeedThis_PR~iNeedThisToo_AV~someText_MK~anotherText_AR~
PR~iNeedThisToo_AN~iNeedThis_AV~someText_MK~anotherText_AR~
Trim AN~ and everything to the left
Keep only text before first _
C:\Users\HANNAH~1.LIS\AppData\Local\Temp\Engine_158196_7e80cb58f1384771aad13906620eb481_\Engine_24124_5ca0b1b7f2f549a6806b6758ab9eaaa4_.yxdb
Single
Profile
Field1 = Left(
Right([Field1],
Length([Field1]) - FindString([Field1], "AN~")...
C:\Users\HANNAH~1.LIS\AppData\Local\Temp\Engine_158196_7e80cb58f1384771aad13906620eb481_\Engine_24124_bede2e59863c4b0fb7d4800b5a273f7f_.yxdb
Single
Profile
Horizontal
Find in string