Parsing strings from two columns

[Ivhee]

Hi All,

I have a file that needs to delimit the data from two columns. I have an example below:

Name	Title1	Title2
Bob	Book1; Book2	The Notebook; Greenhouse
Alex	Book1	One Summer
Sally	Book2; Book3	The Last Song; What's your name?

It should be like this:

Name	Title1	Title2
Bob	Book1	The Notebook
Bob	Book2	Greenhouse
Alex	Book1	One Summer
Sally	Book2	The Last Song
Sally	Book3	What's your name?

I have a script here but it only delimits one column.

Please Login or Register  to view this content.

Thank you very much!

[tigeravatar]

Ivhee,

Welcome to the forum!
Something like this should work for you:

Please Login or Register  to view this content.

[Ivhee]

Wow!! It works!! Thank you very much tigeravatar..

[tigeravatar]

You're very welcome