We would suggest using a combination of a set of fields to extract out the individual Parts of each string and then an Automation to create the child records.
You would have to make an assumption about the maximum number of individual parts on any data upload.
I am just on my iPhone now so I can�t use the formula but you can use the part Function to extract out for example the first part of that, separated field. Then he would have another field for the second part in the third part all the way up to the 10th part.
Then similar that you would extract out 10 fields for the 10 quantities.
Then you would have an automation to write out those 10 records.
But of course in many cases there will not be the full complement of tan line items to be created. So the very last automation could sweep the line items and delete out line items with a blank part number and a blank quantity.
This was dictated to Siri so I hope it�s understandable. Post back if you have any questions.
