Hi we have a module called Invoice Summary, that contains records that are send and populated from an external program, the one I am interested in is a text field (called "Product_Information")  in each individual Invoice Summary which is automatically filled by an API from an external application, the field contains text which is made up of a product group and the tonnage associated with that group in the following format, each product group and its tonnage is deiminated by a , (comma) what I need to do is in the module this appears in for each record, run a workflow when the record is added to extract the text values in the Product_Information text field and populate a table in the record as in the below example.

Cheers Kevin