Question: Modifying Text in a Column
0
gravatar for rasou2ba
4 months ago by
rasou2ba0
rasou2ba0 wrote:

I have a data that is several columns. Below is data from the column I want to modify.

ENSGALT00000021664.5_up_1000_chr1_67101124_f

ENSGALT00000010596.3_up_1000_chr1_8309340_f

ENSGALT00000015976.4_up_1000_chr1_33439188_f

I'd like to modify every row of the column to remove everything starting from the first underscore. So the result should be:

ENSGALT00000021664.5

ENSGALT00000010596.3

ENSGALT00000015976.4

I have not been able to figure out how to do this in Galaxy. Please let me know if there is a tool for this within Galaxy. Thank you.

galaxy data modification • 139 views
ADD COMMENTlink modified 4 months ago by Bjoern Gruening5.1k • written 4 months ago by rasou2ba0
1
gravatar for Bjoern Gruening
4 months ago by
Bjoern Gruening5.1k
Germany
Bjoern Gruening5.1k wrote:

You could use Replace Text in entire line and replace _ with \t and then the cut tool, to extract the first column.

ADD COMMENTlink written 4 months ago by Bjoern Gruening5.1k

I used Replace Text in a specific column (instead of entire line) and the cut tool but it did what I wanted so thank you!

ADD REPLYlink written 4 months ago by rasou2ba0
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 169 users visited in the last hour