AnsweredAssumed Answered

How to Extract Data and Add to another field after a character?

Question asked by bookalaka_1 on Mar 28, 2011
Latest reply on Mar 29, 2011 by LaRetta_1

Title

How to Extract Data and Add to another field after a character?

Post

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]

setfield [table_A::Status"LOV"]

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.

Outcomes