12-05-2005
Convert two column data into 8 columns
Apologies if this has been covered - I did search but couldn't find what I was looking for.
I have a simple X-Y input file. I want to convert it from two columns into 8 columns - 4 pairs of X-Y data. So my input file looks like
X1 Y1
X2 Y2
X3 Y3
X4 Y4
X5 Y5
etc
And I want it to look like this
X1 Y1 X2 Y2 X3 Y3 X4 Y4
X5 Y5 X6 Y6 etc.
I would prefer this to be in specfic format - 8 characters per column. But if that is not possible, each field can be separated with commas.
I thought awk with a printf would be the best way to make this happen, but I can't get it to work.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a program which gives me the output as a single column with hundreds of rows like:
213
314
324
324
123
I want to be able to create a new file from this file which allows me to set the number of rows and columns in the new file, i.e. for this example, if I specify 3 rows and 2... (5 Replies)
Discussion started by: ashton_smith
5 Replies
2. Shell Programming and Scripting
Hi Guys,
I have a file as follows:
a 1
b 786
c 90709
d 99
a 9875
b 989
c 887
d 111
I want:
a 1 9875
b 786 989 (3 Replies)
Discussion started by: npatwardhan
3 Replies
3. Shell Programming and Scripting
Hi Friends
I have the following input data in 2 columns.
SNo 1
I1 Value
I2 Value
I3 Value
SNo 2
I4 Value
I5 Value
I6 Value
I7 Value
SNo 3
I8 Value
I9 Value
...............
................
SNo N (1 Reply)
Discussion started by: ks_reddy
1 Replies
4. UNIX for Dummies Questions & Answers
I have this data
M36 AREA INFORMATION
MDN = 0485009346
ESN = H'15fda0b0
TYPE = HLR
RESULT = NOK
REASON = UNRECOGNIZED MIN
COMPLETED
AREA INFORMATION
MDN = 0498044402
ESN = H'15fdac11
TYPE... (2 Replies)
Discussion started by: krabu
2 Replies
5. UNIX for Dummies Questions & Answers
Hello everyone!
I have a huge dataset looking like this:
nameX nameX 0 1 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 ...............
nameY nameY 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 .....
nameB nameB 0 1 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 .....
(can be several thousands of codes)
and I need... (8 Replies)
Discussion started by: kush
8 Replies
6. Shell Programming and Scripting
Hello All,
Please help me with this file.
My input file (Tab separated) is like:
Abc-01 pc1 -0.69
Abc-01 E2cR 0.459666666666667
Abc-01 5ez.2 1.2265625
Xyz-01 pc1 -0.153
Xyz-01 E2cR 1.7358
Xyz-01 5ez.2 2.0254
Ced-02 pc1 -0.5714
Ced-02 ... (7 Replies)
Discussion started by: mira
7 Replies
7. Shell Programming and Scripting
Hi
I have a ksh script which gives me the output as a single column with several rows like:
AAA
BBB
CCC
DDD
EEE
FFF
GGG
HHH
III
I want to be able to create a new file from this file which allows me to set the number of rows and columns in the new file, i.e. for this example, if I... (30 Replies)
Discussion started by: pinpe
30 Replies
8. UNIX for Advanced & Expert Users
Hi,
I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated.
Thanks. (4 Replies)
Discussion started by: sktkpl
4 Replies
9. UNIX for Dummies Questions & Answers
Dear Unixers,
I'm having some difficulty in converting an n x m data matrix into a dataset of 3 columns and nxm rows. As an example I want to convert this dataset
2 3 4 5
2 0.0 0.0 0.1 0.1
6 -0.3 2.0 0.0 0.3
7 -0.6 -1.1 0.5 0.3
9 -0.9 -4.1 -0.7 0.5
... (2 Replies)
Discussion started by: tintin72
2 Replies
10. Shell Programming and Scripting
Dear All,
We have input like this:
161 57 1378 176 1392 262 1444 441 1548 538 1611 670 1684
241 57 1378 208 1393 269 1447 444 1549 538 1610 677 1700
321 ... (4 Replies)
Discussion started by: attila
4 Replies
COLRM(1) BSD General Commands Manual COLRM(1)
NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
awk(1), column(1), cut(1), paste(1)
HISTORY
The colrm command appeared in 3.0BSD.
BSD
August 4, 2004 BSD