AnsweredAssumed Answered

Separating data into separate fields

Question asked by PaulWebb_1 on May 15, 2015
Latest reply on May 15, 2015 by rouelf_1

Title

Separating data into separate fields

Post

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...

FTX16215DUZ,FTX1622L6AC,FTX1633LUBP,FTX1639L1ZW,FTX1641FLLW

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.

Thanks

FMPA 14

Screen_Shot_2015-05-15_at_15.10.37.png

Outcomes