08-04-2005
it worked! thank you so much. but only one problem left, some of the record being changed. for example,
input record c2 is mad1///mad2///mad3 (one record), output is mad1, ///, mad2, ///, mad3 (file records); can this be fixed? thanks again.
I got your point for post a request. Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I've written a shell function in bash that reads letters into an array, then outputs them in one column with:
for n in "${array}"; do
echo $n
done
I was wondering if anyone knew how i would transpose the letters that are output by the for loop. Right now my output is:
aabbcc... (4 Replies)
Discussion started by: myscsa2004
4 Replies
2. Shell Programming and Scripting
Hello
I need to sort a file with data such as so it breaks on column 1 and all the data in column 2 is sorted into rows with a unique column 1:
1 5
1 6
1 7
2 3
2 4
3 7
3 0
3 9
So it comes out as:
1 5 6 7
2 3 4
3 7 0 9
I've tried many iterations of nawk but can't get it... (14 Replies)
Discussion started by: stevesmith
14 Replies
3. UNIX Desktop Questions & Answers
Hi everyone,
I have a poblem like that:
I have a file which includes data looks like:
0.65214 0.3597 1.0
0.65244 0.3502 1.0
0.65273 0.3553 1.0
0.65305 0.3544 1.0
0.65327 0.3505 1.0
0.65359 0.3516 1.0
0.65578 0.6464 1.0
0.65605 0.6453 1.0
0.65633 0.6437 1.0
0.65660 0.6488 1.0... (3 Replies)
Discussion started by: bulash
3 Replies
4. Shell Programming and Scripting
i have a file as:
1
2
3
4
5
i want output as :
1 2 3 4 5
can anybody help on this?? (14 Replies)
Discussion started by: vikas_kesarwani
14 Replies
5. Shell Programming and Scripting
Hello!
I am very new to Linux and I do not know where to begin...
I have a column with >64,000 elements (that are not in numberical order) like this:
name
2
5
9
.
.
.
64,000
I would like to transpose this column into a row that will later become the header of a very large file... (2 Replies)
Discussion started by: doobedoo
2 Replies
6. Shell Programming and Scripting
Hi All,
I have a input file say FILEA.
FILEA
--------
empid1
sal1
location1
manager1
empid2
sal2
location2
manager2
empid3
sal3
location3
manager3
.
.
. (3 Replies)
Discussion started by: 46019
3 Replies
7. Shell Programming and Scripting
Hi
I do have a big file of the following format
a b c d e f g
2 3 5 6 6 6 7
3 4 5 6 7 9 0
4 5 7 8 9 9 0
1 2 4 5 6 7 8
3 5 6 7 2 3 4
5 6 7 4 3 2 4
5 4 5 6 3 5 5
r h i j k l m
2 3 4 5 6 7 8
4 5 7 8 9 9 0
3 5 6 7 2 3 4
2 3 5 6 6 6 7
5 5 7 8 9 2 3
1 2... (7 Replies)
Discussion started by: Lucky Ali
7 Replies
8. Shell Programming and Scripting
Hi Guys,
I have file containing this kind of format below:
======== MOBILITY EVENT (G): ATTACH REJECT =========
Time : <date_time>
Node : <node>
GMM Cause : <code>
Details : <details>
Attach : <attach type>
IMSI : <imsi>
PTMSI : <ptmsi>
RA New : <ra new>
RA... (9 Replies)
Discussion started by: rymnd_12345
9 Replies
9. Shell Programming and Scripting
Hi
I have a large csv file with lines like below
Date,Status,orig,dest,in,out,when,where
2012-01-01 00:30:37,I,48,56,23,98,83,34
2012-06-17 15:00:38,I,72,43,12,65,34,12I will really appreciate if someone can help with a sed script to transpose this to
2012-01-01 00:30:37,I,orig,48... (5 Replies)
Discussion started by: kaf3773
5 Replies
10. UNIX for Dummies Questions & Answers
Hi,
How do I transpose a huge space delimited file with more than 2 million columns and about 100 rows? Thanks! (10 Replies)
Discussion started by: evelibertine
10 Replies
RLAM(1) General Commands Manual RLAM(1)
NAME
rlam - laminate records from multiple files
SYNOPSIS
rlam [ -tS ][ -u ][ -iaN | -ifN | -idN | -iiN | -iwN | -ibN ] input1 input2 ..
DESCRIPTION
Rlam simply joins records (or lines) from multiple inputs, separating them with the given string (TAB by default). Different separators
may be given for different files by specifying additional -t options in between each file name. Note that there is no space between this
option and its argument. If none of the input files uses an ASCII separator, then no end-of-line character will be printed, either.
An input is either a stream or a command. Commands are given in quotes, and begin with an exclamantion point ('!'). If the inputs do not
have the same number of lines, then shorter files will stop contributing to the output as they run out.
The -ia option may be used to specify ASCII input (the default), or the -if option may be used to indicated binary IEEE 32-bit floats on
input. Similarly, the -id and -ii options may be used to indicate binary 64-bit doubles or integer words, respectively. The -iw option
specifies 2-byte short words, and the -ib option specifies bytes. If a number is immediately follows any of these options, then it indi-
cates that multiple such values are expected for each record. For example, -if3 indicates three floats per input record for the next named
input. In the case of the -ia option, no number indicates one line per input record, and numbers greater than zero indicate that many
characters exactly per record. For binary input formts, no number implies one value per record. For anything other than EOL-separated
input, the default tab separator is reset to the empty string.
A hyphen ('-') by itself can be used to indicate the standard input, and may appear multiple times. The -u option forces output after each
record (i.e., one run through inputs).
EXAMPLE
To join files output1 and output2, separated by a comma:
rlam -t, output1 output2
To join a file with line numbers (starting at 0) and its reverse:
cnt `wc -l < lam.c` | rlam - -t: lam.c -t '!tail -r lam.c'
To join four data files, each having three doubles per record:
rlam -id3 file1.dbl file2.dbl file3.dbl file4.dbl > combined.dbl
AUTHOR
Greg Ward
SEE ALSO
cnt(1), histo(1), neaten(1), rcalc(1), tabfunc(1), total(1)
RADIANCE
7/8/97 RLAM(1)