AnsweredAssumed Answered

comma delimited field

Question asked by aimong on Feb 18, 2014
Latest reply on Feb 20, 2014 by jamesfreddyc
Hello!

I am working with a table and I would like to get this:

number(stored as text)        Code        Year
0500, 0600, 0700               ABC1         2012

to this:

number           Code          Year
0500               ABC1        2012
0600               ABC1        2012             
0700               ABC1        2012

I have gotten to where I can insert each number/space/comma into a new row but obviously I need it to break it at the commas. Ideas?

Outcomes