Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi, To All the GURUs on this forum. 3

Status
Not open for further replies.

suddu

IS-IT--Management
Apr 16, 2003
37
US
Hi, To All the GURUs on this forum. You guys have been a great help all the way in my various projects. I am faced with a unique problem this time. I have a table full of values with approx 3000 records. What I want to do is get the data from one of the cells to seprate into as many records as seprators in that field and get the rest of the data to repeat in those records. for example

Generic Trade Name Dosage Form Usual Dose
A BAC Caps 10, 20, 50

What I want to get is:
Generic Trade Name Dosage Form Usual Dose
A BAC Caps 10
A BAC Caps 20
A BAC Caps 50


Any and all the help will be greatly appreciated, Thanks In advance
 
Thanks A lot Everyone, yo both seserve a star. It worked.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top