Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Remove bracket part entires and separate entries after comma
Top Forums Shell Programming and Scripting Remove bracket part entires and separate entries after comma Post 302731519 by Priyanka Chopra on Thursday 15th of November 2012 10:37:58 PM
Old 11-15-2012
Code:
PRSS53 (PA165450635),VKORC1 (PA133787052)       warfarin (PA451906)     Allele T is associated with increased dose of warfarin .
PRSS53 (PA165450635),VKORC1 (PA133787052)       warfarin (PA451906)     Genotype AA is associated with increased dose of warfarin .
        warfarin (PA451906)     Allele T is associated with increased dose of warfarin .
        warfarin (PA451906)     Allele T is associated with increased dose of warfarin .
        warfarin (PA451906)     Allele G is associated with increased dose of warfarin .
        warfarin (PA451906)     Allele G is associated with increased dose of warfarin .

This one I want o remove bracket part and make duplicate row for entry after comma

Code:
PRSS53   warfarin   Allele T is associated with increased dose of warfarin .

VKORC1    warfarin   Allele T is associated with increased dose of warfarin .


PRSS53   warfarin   Allele T is associated with increased dose of warfarin .

VKORC1    warfarin   Allele T is associated with increased dose of warfarin .

ANd next one in same way but I appreciat u reminde me abu this:


Code:
UGT1A1  fluorouracil Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

UGT1A10 fluorouracil Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo
UGT1A3 fluorouracil  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo
UGT1A4 fluorouracil  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo
UGT1A5 fluorouracil  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo
UGT1A6  fluorouracil  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo
UGT1A7 fluorouracil  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo
UGT1A8 fluorouracil  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo
UGT1A9 fluorouracil  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo


UGT1A1  irinotecan         Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

UGT1A3 irinotecan Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

UGT1A10 irinotecan  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

UGT1A4   irinotecan  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

UGT1A7     irinotecan  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

UGT1A5      irinotecan    Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

UGT1A6          irinotecan     Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

UGT1A1        leucovorin     Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo	

UGT1A3      leucovorin 	 Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

UGT1A10      leucovorin 	Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo	
 
UGT1A4  leucovorin 	 Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovorin	

UGT1A7     leucovorin 	 Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo	

UGT1A5        leucovorin  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo	

UGT1A6   leucovorin  Genotype (TA)7/(TA)7 is associated with increased likelihood of Neutropenia when treated with fluorouracil, irinotecan and leucovo

---------- Post updated at 10:37 PM ---------- Previous update was at 08:57 AM ----------

Can anyone please check above question and code which I tried as I need it urgently.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

count data separate by comma

hi experts, i have some problem with count data which separate by comma, below sample data : 01,011222823b6d,011222823f29,0028a5,002993,6212345678, 659111111111,6598204507,6281105008,6596197849,_,525016160836958,_, ffffffff,000000000000000000000000,_,_,_,fd,fd,ff,00,1,0028a5-002993,_,... (10 Replies)
Discussion started by: bucci
10 Replies

2. Solaris

How to remove setfacl entires for a file

I gave the permission for a user using Setfacl as folllows setfacl -m u:user:rwx,m:rwx /home/master To a home path of a master user When i try to remove the same it showing as $ setfacl -r s /home/master usage: setfacl -f aclfile file ... setfacl -d... (2 Replies)
Discussion started by: GIC1986
2 Replies

3. Shell Programming and Scripting

using diff to on two file but ignoring the last comma separate value

Hi guys I have two file which I sdiff. ie file 1: AA,12,34,56,,789,101,,6666 file 2: AA,12,34,56,,789,101,,7777 The last comma separated value will always change from one day to the next. Is there another unix utility I can use that will sdiff two files but ignore the last comma... (1 Reply)
Discussion started by: wny201
1 Replies

4. Shell Programming and Scripting

ksh, difference between double bracket and single bracket

Can somebody tell me the difference between double brackets and single brackets, when doing a test. I have always been acustomed to using single brackets and have not encountered any issues to date. Why would somebody use double brackets. Ie if ] vs if Thanks to... (2 Replies)
Discussion started by: BeefStu
2 Replies

5. Shell Programming and Scripting

Remove bracket part

Hi I have to remove in a file in first column whatever is written in brackets with brackets so one file hgfd 123 gfhdj 483 jdgfdg 34738 the output shuld be hgfd 123 gfhdj 483 jdgfdg 34738 (9 Replies)
Discussion started by: manigrover
9 Replies

6. Shell Programming and Scripting

Separate Entries after comma

Hi All I need help to separate entries after commas in my I have 2 columns in my file like this Ramush, Shyam, Mohan First Ram, Mohan, Kaavya Second, Fourth Kavi, Ram, Shaym, Mohan Third I ahve to separate entries after comma in a separate row... (9 Replies)
Discussion started by: kareena
9 Replies

7. UNIX for Advanced & Expert Users

Comma separate issue in UNIX

In awk the field seprator is not working properly, I am trying to cut the fields from the file based on the delimiter example comma (,) awk -F, "{print {$1 FS $3 FS $5 FS FS $2}}" Sample.csv But i am not getting desired output can anyone help me how to check real ascii comma there in my... (9 Replies)
Discussion started by: rspwilliam
9 Replies

8. Shell Programming and Scripting

How to remove contents from file which are under bracket?

hello Friend, In hostgroup file, i have define lots of hostgroups. I need to remove few of them without manually editing file. Need script or syntax. I want to search particular on hostgroup_members and delete hostgoup defination of it. for example. define hostgroup{ hostgroup_name... (8 Replies)
Discussion started by: ghpradeep
8 Replies

9. Shell Programming and Scripting

Remove bracket including text inside with sed

Hello, I could not remove brackets with text contents myfile: Please remove the bracket with text I wish to remove: I tried: sed 's/\//' myfile It gives: Please remove the bracket with text A1 I expect: Please remove the bracket with text Many thanks Boris (2 Replies)
Discussion started by: baris35
2 Replies
All times are GMT -4. The time now is 06:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy