AnsweredAssumed Answered

Split fields into several records

Question asked by JelleLisson on Jan 27, 2014
Latest reply on Jan 28, 2014 by philmodjunk

Title

Split fields into several records

Post

      

     Hi Everybody, I am new to this forum.
      

     I have a table with 5 columns:
     - a number (“Source_ID”)
     - Name (“Per_Nr”)
     - Category (“Cat_Nr”)
     - Year (“Year”)

     The “Cat_Nr”-column contains different numbers, seperated with “; ” (a semicolon, followed by a space)

     e.g.:

     1          Tom     2; 12; 26; 37    2012
     2          John    12; 17               2009

      

     I need to split the information in the “Cat_Nr”-column, but the other columns have to stay the same

     e.g.:

     1          Tom      2         2012
     1          Tom     12        2012
     1          Tom     26        2012
     1          Tom     37        2012
     2          John    12        2009
     2          John    17        2009

     Since I have about a 1000 records, I was hoping someone could help me find a way to do this automatically?


     Kind regards,
     Jelle

Outcomes