Separating data into separate fields
I need the equivalent of Text to Columns in Excel. I have a field Serial ID that when imported can have one or more values. I created 10 additional fields Serial 1 to Serial 10. The data coming in looks like...
I want to separate this out into 5 separate fields. I am trying to build a formula that will pull each serial number out and put it into a field using Auto Enter - Calculated Value
Need some guidance.