03-23-2009
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:
Quote:
$ sed 's/\(.*\)-[^ ]*\(.*\)/\1\2/' Controlvs-HIV-HIVMDD-HIVE-2_KMcluster_output.txt > Controlvs-HIV-HIVMDD-HIVE-2_KMcluster_output_trimmed.txt
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:
Quote:
hsa-miR-518e-4395506 -1.308 -3.079
hsa-miR-369-3p-4373032 1.612 -4.058
hsa-miR-216b-4395437 3.878 -4.009
And last 3 rows of output:
Quote:
hsa-miR-518e-4395506 -1.308 -3.079
hsa-miR-369-3p-4373032 1.612 -4.058
hsa-miR-216b-4395437 3.878
Thanks again.
-E
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have few files in unix which are in dos format. While I am copying these files, ^M, ^@, etc characters are being generated.
I tried dos2unix command in Linux and it doesn't work.
I tried sed to remove these characters but they won't go.
I came to about this 'tr' command and tried to use it... (16 Replies)
Discussion started by: chiru_h
16 Replies
2. HP-UX
Hi,
I have a very huge file and it contains some unprintable characters like ^H and ^D.
If I try to remove using cat test1.ser| tr -d '\136 110'>newfile1 it is only removing ^and all spaces in the file.
How can I remove these characters (^D ^H) and keep my spaces as it is?
Thanks &... (1 Reply)
Discussion started by: arsheshadri
1 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
Any help on how to do the following? :eek:
I have an infile as follows:
_thisishowyouwritehelloworld
_thisisalsohowyouwritehelloworld2
I want to delete the characters from "_" to "how" and be left with:
youwritehelloworld
youwritehelloworld2
I am able to do delete from a... (2 Replies)
Discussion started by: dr_sabz
2 Replies
4. UNIX for Advanced & Expert Users
hi
I have a perl script conv.pl. when i execute this file and direct i to log file I see lots of ^M characters in the log file. There is no ^M in conv.pl file. Log file is generated only after conv.pl is executed.
Please help as how to get rid of these.
This conv.pl is going to get schduled... (0 Replies)
Discussion started by: infyanurag
0 Replies
5. UNIX for Dummies Questions & Answers
hi
I have a perl script conv.pl. when i execute this file and direct i to log file I see lots of ^M characters in the log file. There is no ^M in conv.pl file. Log file is generated only after conv.pl is executed.
Please help as how to get rid of these.
This conv.pl is going to get schduled... (5 Replies)
Discussion started by: infyanurag
5 Replies
6. Shell Programming and Scripting
Hi,
I want to removing ^M characters from a file and combine the line with the next line.
ex:
issue i have:
ABC^M^M
DEF
solution i need:
ABCDEF
I found that you by using the following command you can remove new line characters.
tr -d '\r' < infile.csv > outfile.csv
still... (10 Replies)
Discussion started by: mwrg
10 Replies
7. Shell Programming and Scripting
I have a file as follows
ATOM 5181 N AMET K 406 12.440 6.552 25.691 0.50 7.37 N
ATOM 5182 CA AMET K 406 13.685 5.798 25.578 0.50 5.87 C
ATOM 5183 C AMET K 406 14.045 5.179 26.909 0.50 5.07 C
ATOM 5184 O MET K... (14 Replies)
Discussion started by: hasanabdulla
14 Replies
8. UNIX for Dummies Questions & Answers
I am trying to remove trailing carriage return (x'0a') from a source program. What is a good way to do this for the whole file?
TIA (4 Replies)
Discussion started by: wbport
4 Replies
9. Shell Programming and Scripting
bash-3.00$ cat temp.txt
./a/REA01/ces1/apps/ces_ces1_init3_aa.ear/ces.war/WEB-INF/classes/reds/common/environment.properties
./a/REA01/ces1/apps/ces_ces1_init3_aa.ear/commonproperties/hi/HostIntegration.properties... (9 Replies)
Discussion started by: bhas85
9 Replies
10. Shell Programming and Scripting
Hi,
I have pipe separated file which contains some data having comma(,) in it. I want to remove the comma(,) only from particular column without changing data in other columns.
Below is the sample data file, I want to remove the comma(,) only from 5th column.
$ cat file1
ABC | DEF, HIJ|... (6 Replies)
Discussion started by: Prathmesh
6 Replies
PSC(1) General Commands Manual PSC(1)
NAME
psc - prepare sc files
SYNOPSIS
psc [-fLkrSPv] [-s cell] [-R n] [-C n] [-n n] [-d c]
DESCRIPTION
Psc is used to prepare data for input to the spreadsheet calculator sc(1). It accepts normal ascii data on standard input. Standard out-
put is a sc file. With no options, psc starts the spreadsheet in cell A0. Strings are right justified. All data on a line is entered on
the same row; new input lines cause the output row number to increment by one. The default delimiters are tab and space. The column for-
mats are set to one larger than the number of columns required to hold the largest value in the column.
OPTIONS
-f Omit column width calculations. This option is for preparing data to be merged with an existing spreadsheet. If the option is not
specified, the column widths calculated for the data read by psc will override those already set in the existing spreadsheet.
-L Left justify strings.
-k Keep all delimiters. This option causes the output cell to change on each new delimiter encountered in the input stream. The
default action is to condense multiple delimiters to one, so that the cell only changes once per input data item.
-r Output the data by row first then column. For input consisting of a single column, this option will result in output of one row
with multiple columns instead of a single column spreadsheet.
-s cell
Start the top left corner of the spreadsheet in cell. For example, -s B33 will arrange the output data so that the spreadsheet
starts in column B, row 33.
-R n Increment by n on each new output row.
-C n Increment by n on each new output column.
-n n Output n rows before advancing to the next column. This option is used when the input is arranged in a single column and the
spreadsheet is to have multiple columns, each of which is to be length n.
-d c Use the single character c as the delimiter between input fields.
-P Plain numbers only. A field is a number only when there is no imbedded [-+eE].
-S All numbers are strings.
-v Print the version of psc
SEE ALSO
sc(1)
AUTHOR
Robert Bond
PSC 7.16 19 September 2002 PSC(1)