How to Extract Data and Add to another field after a character?
I receive an inventory report that I need to manipulate not sure how to break the information out. imported into filemaker from excel my first field data reads; LOV...AA, 2ND FIELD; N1001009 ALBACORE. The end result shoub be Field 1_ITEMCODE: AAN1001009 Field 2; ItemName:ALBACORE Field 3 STATUS; LOV
Currently my script is
go to field[table_A::itemcode]
perfom find/replace["lOV...","" replace&find]
Where I am stuck is on the 2nd Field. how do I get the 8 characters over to the first field and paste after the first two characters ending up with "AAN1001009"
If I use Right ( TABLE_A::description ; 8 ) this extracts the characters but doesn't give me what I need to do which is to paste to the first field.
Thanks for guidance.