AnsweredAssumed Answered

Taking values seperated by commas in one Field and copying them into seperate fields

Question asked by WilliamK on Jan 10, 2013
Latest reply on Jan 11, 2013 by WilliamK

Title

Taking values seperated by commas in one Field and copying them into seperate fields

Post

     After importing data I have a field "ItemTitle" that has data like this

ShippingService:USPS Parcel Post, Tracking #: 9434609699939412855702, Postage: $18.37, Insurance: $0.00

From that field I want to extract the data USPS Parcel Post and put it in a field called "Shipping Service".  I also want to extract the actual Tracking Number and put it in a field called "Tracking Number". 

I tried a script that used the SetField with the MiddleWords Function and had limited success.  Because each value in the field is seperated by a comma, I think the best way is to parse the string and pull the data I want using the comma.  In other programs you could do this by creating an array.

So bascially I want to tell FM Pro grab all text before first comma and put it in field "Shipping Service".  Grab all data between first comma and second comma and put it in field "Tracking Number".

How can I do this in FileMaker Pro?

Outcomes