07-15-2009
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
input
COL1 a1 b1 c1 d1 e1 f1
C1 10 10 10 100 100 1000
C2 20 20 200 200 200 2000
output
C1 a1 10 1
C1 b1 10 1
C1 c1 10 1
C1 d1 100 2
C1 e1 100 2
C1 f1 1000 3
C2 ... (12 Replies)
Discussion started by: ruby_sgp
12 Replies
2. Shell Programming and Scripting
Hello
I have file that consist of 2 columns of millions of entries
timestamp and throughput
I want to find the average (throughput ) for each equal timestamp before change it to proper format
e.g : i want to average 2 coloumnd fot all 1308154800 values in column 1
and then
print... (4 Replies)
Discussion started by: aadel
4 Replies
3. Shell Programming and Scripting
Hi i have data with two columns like below.
I want to find average of column values like if the value in column 2 is between 0-250000 the average of column 1 is some xx and average of column2 is ww then if value is 250001-5000000 average of column 1 is yy and average of column 2 is zz.
And my... (5 Replies)
Discussion started by: bhargavpbk88
5 Replies
4. Shell Programming and Scripting
My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated.
Please someone help me to resolve this issue.
Source
column1 column2 column3 column4... (2 Replies)
Discussion started by: Ganesh L
2 Replies
5. Shell Programming and Scripting
Hello,
I have a data such as this:
ENSGALG00000000189 329 G A 4 2 0
ENSGALG00000000189 518 T C 5 1 0
ENSGALG00000000189 1104 G A 5 1 0
ENSGALG00000000187 3687 G T 5 1 0
ENSGALG00000000187 4533 A T 4 2 0
ENSGALG00000000233 5811 T C 4 2 0
ENSGALG00000000233 5998 C A 5 1 0
I want to... (3 Replies)
Discussion started by: Homa
3 Replies
6. Shell Programming and Scripting
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies
7. UNIX for Dummies Questions & Answers
Dear all ...
I have a file which I want to change the structure based on the values in some columns and I would be grateful if you can help...
one of my files looks like ... they all have ten rows
1,0,0
10,0,0
2,0,0
3,0,0
4,1,1
4,1,1
4,1,1
5,0,0
6,0,0
7,0,0
8,0.5,2
9,0.33,3
9,0.33,3... (1 Reply)
Discussion started by: A-V
1 Replies
8. Shell Programming and Scripting
Hi,
Please help to fetch the values for a key from below data format in linux.
Sample Input Data Format
11055005|PurchaseCondition|GiftQuantity|1
11055005|PurchaseCondition|MinimumPurchase|400
11055005|GiftCatalogEntryIdentifier|Id|207328014
11429510|PurchaseCondition|GiftQuantity|1... (2 Replies)
Discussion started by: mohanalakshmi
2 Replies
9. Shell Programming and Scripting
I have a file (myfile.txt) with contents like this:
1.txt apple is
3.txt apple is
5.txt apple is
2.txt apple is a
7.txt apple is a
8.txt apple is a fruit
4.txt orange not a fruit
6.txt zero isThe above file is already sorted using this command:
sort -k2 myfile.txtMy objective is to get... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies
10. UNIX for Beginners Questions & Answers
Hi there,
I am trying to filter a big file with several columns using values on a column with values like (AC=5;AN=10;SF=341,377,517,643,662;VRT=1). I wont to filter the data based on SF= values that are (bigger than 400)
... (25 Replies)
Discussion started by: daashti
25 Replies
LEARN ABOUT OSF1
dos2unix
dos2unix(1) General Commands Manual dos2unix(1)
NAME
dos2unix - mtools utility to convert a DOS file to UNIX
SYNOPSIS
dos2unix msdosfile
OPTIONS
None
OPERANDS
Name of the file to convert.
DESCRIPTION
The dos2unix command converts a file from DOS format to UNIX format. The converted file replaces the original file.
Subdirectory names that contain the '/' or '' separator are supported. If you use the '' separator or wildcards, you must enclose file
names in quotes to protect them from the shell.
The mcd command can be used to establish the device and the current working directory (relative to DOS), otherwise the default is A:.
EXIT STATUS
The following exit values are returned: Success. Failure.
ENVIRONMENT VARIABLES
The following environment variables affect the execution of dos2unix: If set, this variable names the file that contains the name of the
current mtools working directory as established by the mcd command. If this variable is not set, the file $HOME/.mcwd is used.
FILES
Contains the name of the current mtools working directory as established by the mcd command. If this file does not exist, the default
mtools working directory is A:. Executable file
SEE ALSO
Commands: mcopy(1), mread(1), mtools(1) mtype(1), mwrite(1)
dos2unix(1)