11-08-2008
Dear Rado,
I have tried the solution given by you and its working perfect. Just to know, what if i want the output file to be pipe (|) separated instead of comma (,)?
And secondly as you have asked if I have tried perl. I dont know how to use perl for it. It would be really great if you guide me thro it as well.
Thank you for all your help.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Dear UNIX experts:
Hi, I have a text file which the contents are arranged vertically down, line by line.
How do use a loop (I think) to make it arrange in vertical arrangement with a tab delimitated and write to a new file?
Eg: of source file
Hello World
Good-day
Thanks
Welcome
The... (8 Replies)
Discussion started by: merry susana
8 Replies
2. UNIX for Dummies Questions & Answers
I have these following data:
Home Tom
Member List
100 Yes
200 No
Home Tom
Member List
1 No
2 Yes
Home Tome
Member List
3 No
400 Yes
I want my data to be consistants like this: (4 Replies)
Discussion started by: bobo
4 Replies
3. UNIX for Dummies Questions & Answers
I have a data file with hundreds of lines: I want to place a YES right below the line that say mydata....can someone please help! on the left is my the original data on the right the data format need to be:
left > Right
mydata > mydata
yes > yesno > no
mydata > mydata... (12 Replies)
Discussion started by: bobo
12 Replies
4. UNIX for Dummies Questions & Answers
10 2 1 2 3 4 5 6 7 8
20 3 2 1 3 2 9 8 2 1
Need the data to be arranged:
10 2 1 5
2 6
3 7
4 8
20 3 2 1
1 2
3 8
2 9
please help! (6 Replies)
Discussion started by: bobo
6 Replies
5. UNIX for Dummies Questions & Answers
Can anyone help me on this. I have a file that looks like this:
color red green blue
color pink yellow
number one two
gender male
gender female
The output would look like this:
color red green blue pink yellow
number one two
gender male female
I have over 5000 rows and i dont want... (5 Replies)
Discussion started by: kharen11
5 Replies
6. Shell Programming and Scripting
Hi,
I have the following 'sorting' problem.
Given the input file:
a:b:c:12:x:k
s:m:d:8:z:m
a:b:c:1:x:k
p:q:r:23:y:m
a:b:c:3:x:k
p:q:r:1:y:m
the output I expect is:
a:b:c:1:x:k
p:q:r:1:y:m
s:m:d:8:z:m
What happened here is I grouped together lines having the same values for... (7 Replies)
Discussion started by: Abhishek Ghose
7 Replies
7. Shell Programming and Scripting
Input file
<data id>="1">\
</data>\
<data id>="2">\
</data>\
<code>="1" target="2">\
</code>\
<data id>="1">\
</data>\
<data id>="2">\
</data>\
<code>="1" target="2">\
</code>\
<data id>="1">\
</data>\
<data id>="2">\
</data>\
<code>="1" target="2">\
</code>\ (2 Replies)
Discussion started by: cpp_beginner
2 Replies
8. Shell Programming and Scripting
Input file:
<symbol>Q9Y8G1</symbol>
<name>Q9Y8G1_EMENI</name>
<symbol>Q6V953</symbol>
<symbol>Q5B8K1</symbol>
<name>Q6V953_EMENI</name>
<symbol>G1A416</symbol>
<name>G1A416_9FUNG</name>
<symbol>D4N894</symbol>
<name>D4N894_PLEER</name>
<symbol>B0FFU4</symbol>... (13 Replies)
Discussion started by: cpp_beginner
13 Replies
9. UNIX for Advanced & Expert Users
Hi
I have a huge problem to solve ASAP. Can someone please help!!!
My format is arranged in this format: It has three columns.
LOGIN ALIAS REC_ID
A BB1 0
A ... (1 Reply)
Discussion started by: Mapilo
1 Replies
10. Shell Programming and Scripting
Hi all
I have following part of a big file
TTDS00002 Synonyms M1 receptor
TTDS00002 Disease Alzheimer's disease
TTDS00002 Disease Bronchospasm (histamine induced)
TTDS00002 Disease Cognitive deficits
TTDS00002 Disease Schizophrenia
TTDS00002 Function The muscarinic acetylcholine... (2 Replies)
Discussion started by: kareena
2 Replies
HISTO(1) General Commands Manual HISTO(1)
NAME
histo - compute 1-dimensional histogram of N data columns
SYNOPSIS
histo [-c][-p] xmin xmax nbins
histo [-c][-p] imin imax
DESCRIPTION
Histo bins columnular data on the standard input between the given minimum and maximum values. If three command line arguments are given,
the third is taken as the number of data bins between the first two real numbers. If only two arguments are given, they are both assumed
to be integers, and the number of data bins will be equal to their difference plus one. The bins are always of equal size.
The output is N+1 columns of data (for N columns input), where the first column is the centroid of each division, and each row corresponds
to the frequencies for each column around that value.
If the -c option is present, then histo computes the cumulative histogram for each column instead of the straight frequencies. The upper
value of each bin is printed also instead of the centroid. This may be useful in computing percentiles, for example. Values below the
minimum specified are still counted in the cumulative total.
The -p option tells histo to report the percentage of the total number of input lines rather than the absolute counts. In the case of a
cumulative total, this yields the percentile values directly. Values above the maximum are counted as well as values below in this case.
All input data is interpreted as real values, and columns must be white-space separated. If any value is less than the minimum or greater
than the maximum, it will be ignored unless the -c option is specified.
EXAMPLE
To count data values between -1 and 1 in 50 bins:
histo -1 1 50 < input.dat
To count frequencies of integers between 0 and 255:
histo 0 255 < input.dat
AUTHOR
Greg Ward
SEE ALSO
cnt(1), neaten(1), rcalc(1), rlam(1), tabfunc(1), total(1)
RADIANCE
9/6/96 HISTO(1)