Use Substitute ( Textfield ; "|" ; ¶ )
to replace the pipe characters with returns.
You can then use GetValue to extract the data that was originally separated by pipe characters via a looping script that can move the data into a related table.
Great idea! So would you set up a dummy field in the item table to import the item data to initially?
Not in the item table.
Seems like you'd need at least these tables:
You'd import your data into orders with a text field there that receives the delimitted item data. A looping script could then move the data from that text field into new records in LineItems (This is called invoiceData in the invoices starter solutions)
You can use variables to move the data from Orders to LineItems at the time your looping script parses the data.