Latest
Open
RNA-Seq
ChIP-Seq
SNP
Assembly
Forum
Planet
All »
Home
Log In
Question: Modifying Text in a Column
0
gravatar for rasou2ba
4 months ago by
rasou2ba • 0
rasou2ba • 0 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 COMMENT • link •
modified 4 months ago by Bjoern Gruening ♦ 5.1k • written 4 months ago by rasou2ba • 0
1
gravatar for Bjoern Gruening
4 months ago by
Bjoern Gruening ♦ 5.1k
Germany
Bjoern Gruening ♦ 5.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 COMMENT • link written 4 months ago by Bjoern Gruening ♦ 5.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 REPLY • link written 4 months ago by rasou2ba • 0
Please log in to add an answer.

Similar posts • Search »

Content
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