|
sheel331
Starting Member
1 Posts |
 Posted - 09/18/2012 : 12:06:08
|
Hello,
I have a SQL query that puts my data into the following format (sorry for the format, 5588 is ID, the semicolon delimited items are AUTH_ID, 2010 Boot camp is PUB_Name, 11 is PUBL_MO, 2010 is PUBL_YR, Impact... is title, and Darrell,John,Donna are Author_NAME):
id AUTH_ID PUB_NAME PUBL_MO PUBL_YR TITLE AUTHOR_NAME
5588 ;39830;39050;27472 2010 Boot Camp 11 2010 Impact of International Changes Darrell,John,Donna
I want to split out the AUTH_ID into individual rows, with one ID number in each row, but all of the other information can be the same. The number of items in the AUTH_ID column could be 1 number, or it could be several (4-5). Unfortunately I'm not familiar with how to do this, so any help would be appreciated.
Thanks in advance,
Sheel |
|
Split column by semi colon
