Shell Programming and Scripting

Hi all

I have following kind of data in a file but non separated

Code:

ESR1 PA156 leflunomide PA450192 
CHST3 PA26503  docetaxel tungstate  Pa4586; thalidomide Pa34958;

I want to separate entries into columns so that I can put into excel sheet in proper arrangement.

I want entries starting PAxxx/PAxxxx in a columns

so that for first row I will have entries arranged in 4 columns

and for second row I will have entries in 6 columns

Expected output in columns thats it

Code:

ESR1 PA156 leflunomide PA450192 
CHST3 PA26503  docetaxel tungstate  Pa4586; thalidomide Pa34958;

Although its not very clear to me what you've asked but this is what I can recommend to you.

I can already see that in your original text there are spaces. So, you can use the import wizard in Excel to import the contents into your excel sheet.

Hi Shoaib

Thanks for reply

Yes I tried to separate columns based on space but its not wrking properly as for example there is space between "docetaxel tungstate" which shuld come in one column, but if we separate by space it will get separated which I do not want in output.

so the only thing I can see id PAxxx entries , if these entries get separated into columns other entries will be in column automatically which I want in output.

so for first row there will be 4 columns
and second row 6 columns

Code:

ESR1 PA156 leflunomide PA450192 
CHST3 PA26503  docetaxel tungstate  Pa4586; thalidomide Pa34958;

One way could be to put underscore between the words appearing between PAxxx's and then import in Excel and in Excel find and replace all underscores with spaces.

Thankyou

Could u please advise me regarding script which can help me to put underscore between PA entries as there are some places ; sign present.

Kindly advise me regardin script as I think I shuld first remove ; sign and then put underscore

I just need guidance regarding underscore between PAxxx/PAxxxx entries

Thanks
Mani