UNIX for Dummies Questions & Answers

I have a file that looks like this:

hsa-miR-517b-4373244 0 4.116
hsa-miR-886-5p-4395304 1.173 1.95
hsa-miR-551b-4380945 1.62 1.722
hsa-miR-886-3p-4395305 1.479 3.074
hsa-miR-125a-3p-4395310 1.246 2.697
hsa-miR-874-4395379 1.985 1.721

I want it too look like this:

hsa-miR-517b 0 4.116
hsa-miR-886-5p 1.173 1.95
hsa-miR-551b 1.62 1.722
hsa-miR-886-3p 1.479 3.074
hsa-miR-125a-3p 1.246 2.697
hsa-miR-874 1.985 1.721

...etc.

Any suggestions using unix and / or perl commands?
~much appreciated in advance.

try this simple sed command

Code:

sed 's/\(.*\)\(-.*\)\( [0-9].* \)\(.*\)/\1\3\4/g' filename

Another approach:

Code:

sed 's/\(.*\)-[^ ]*\(.*\)/\1\2/' file

Regards

Thank you very much for replying. Neither of those solutions worked.

I think that all that happened was it removed the last value from the last column (in perl, Column 2). The file has 3 columns (0, 1, 2); the first column is a name and the other two are values (measurements). I want to import these files into a graphing program. The name, though, has extraneous information in it (ie: the last ten characters are catalogue numbers).

the kind of the i/p and o/p you provided can be obtained by both of these commands so if your req changed please put the correct i/p and o/p

It should work, this is my output:

Code:

$ cat file
hsa-miR-517b-4373244 0 4.116
hsa-miR-886-5p-4395304 1.173 1.95
hsa-miR-551b-4380945 1.62 1.722
hsa-miR-886-3p-4395305 1.479 3.074
hsa-miR-125a-3p-4395310 1.246 2.697
hsa-miR-874-4395379 1.985 1.721
$
$ sed 's/\(.*\)-[^ ]*\(.*\)/\1\2/' file
hsa-miR-517b 0 4.116
hsa-miR-886-5p 1.173 1.95
hsa-miR-551b 1.62 1.722
hsa-miR-886-3p 1.479 3.074
hsa-miR-125a-3p 1.246 2.697
hsa-miR-874 1.985 1.721
$

Regards

Maybe I am misunderstanding how to do something. I am operating in the "Terminal" of a Mac OS. I navigated to the appropriate dir.

My input file is a tab-delimited text file that looks like above.

The command I entered was this:

The output file looks mostly the same except at the very end, where the 3rd column is truncated from the final row.

IE:
Last 3 rows of input:
And last 3 rows of output:
Thanks again.
-E