Taking values seperated by commas in one Field and copying them into seperate fields
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?