Ok. Lets make it simple. I have got the data into a csv file as follows.
Code:
A,"YAHOO3456-K9YAHOO9876YAHOO67/2YAHOO65432-1"
B,"YAHOO01YAHOO07865YAHOO67-AD987/1YAHOO67/23"
And what I want as the output is
Code:
A,YAHOO3456-K9
A,YAHOO9876
A,YAHOO67/2
A,YAHOO65432-1
B,YAHOO01
B,YAHOO07865
B,YAHOO67-AD987/1
B,YAHOO67/23
The format that would be common is YAHOOxxxxx in the 2nd column.
Let me know if you can think of an easy conversion.
Thanks,
Rahul.
|
