06-06-2011
How to convert a single column into several columns?
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 specify 3 rows and 3 columns, the output should look like
file.txt:
AAA DDD GGG
BBB EEE HHH
CCC FFF III
Is it possible to do this in Unix using sed command and in comma separated?
I tried
cat file.txt | sed 'N;N;s/\n/,/g'
but its giving me wrong output.
Thank You,
Pinpe
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
I have a single column of data that I would like to cut/print (with awk or ...) into multiple columns at every empty row (or common character).
Input:
5.99123
5.94693
7.21383
5.95202
0.907935
5.99149
6.08427
0.975774
6.077
Output:
5.99123 5.95202 6.08427
5.94693... (7 Replies)
Discussion started by: agibbs
7 Replies
2. Shell Programming and Scripting
Hi -
I'm new to the awk programming language. I'm trying to print a single column of data to several columns, and I found an article on iTWorld.com (ITworld.com - Printing in columns). It looks like the mkCols2 script is very close to what I need to do, but it looks like the end of the code... (2 Replies)
Discussion started by: astroDave
2 Replies
3. 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
4. Shell Programming and Scripting
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... (8 Replies)
Discussion started by: NickC
8 Replies
5. Shell Programming and Scripting
Hello Experts,
I am new to this forum, I would like to do the following changes in one of the column of a txt file, which is having around 9 column.
For example, column 3 is having letters like this
AB11
AB12
C
CA
CB
AC1
AC2
I would like to convert the same column as follows
... (5 Replies)
Discussion started by: Fredrick
5 Replies
6. Shell Programming and Scripting
Hello all
I have data like
1
2
3
4
5
I wish my output would be like
1,2,3,4,5
For this i have executed
'BEGIN {FS="\n"; ORS=","} {print $0}' test
and got the output as
1,2,3,4,5,
I do not want to have , at the end of 5. output should be like (5 Replies)
Discussion started by: vasuarjula
5 Replies
7. 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
8. Shell Programming and Scripting
I have this input:
10 22 1 100
11 22 10 1 50
14 3 1 100
23 3 1 100
24 15 1 100
10 22 5 3 1 33.333
11 22 1 100
It has an inconsistent number of fields but the last field is determined by 100/(NF-2) using awk.
I want to take this multiple columned input file and transform so that... (2 Replies)
Discussion started by: mdlloyd7
2 Replies
9. Shell Programming and Scripting
Convert Single column to multiple rows
file a.txt contains data like below
Server=abc
Run=1
Tables=10
Sessions=16
Time=380
Jobs=5
Server=abc
Run=2
Tables=15
Sessions=16
Time=400
Jobs=5
Server=abc
Run=3
Tables=20
Sessions=16
Time=450 (5 Replies)
Discussion started by: sol_nov
5 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
LEARN ABOUT PHP
pdostatement.fetchcolumn
PDOSTATEMENT.FETCHCOLUMN(3) 1 PDOSTATEMENT.FETCHCOLUMN(3)
PDOStatement::fetchColumn - Returns a single column from the next row of a result set
SYNOPSIS
public mixed PDOStatement::fetchColumn ([int $column_number])
DESCRIPTION
Returns a single column from the next row of a result set or FALSE if there are no more rows.
Note
PDOStatement.fetchColumn(3) should not be used to retrieve boolean columns, as it is impossible to distinguish a value of FALSE from
there being no more rows to retrieve. Use PDOStatement.fetch(3) instead.
PARAMETERS
o $column_number
- 0-indexed number of the column you wish to retrieve from the row. If no value is supplied, PDOStatement.fetchColumn(3) fetches
the first column.
RETURN VALUES
PDOStatement.fetchColumn(3) returns a single column in the next row of a result set.
Warning
There is no way to return another column from the same row if you use PDOStatement.fetchColumn(3) to retrieve data.
EXAMPLES
Example #1
Return first column of the next row
<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();
print("Fetch the first column from the first row in the result set:
");
$result = $sth->fetchColumn();
print("name = $result
");
print("Fetch the second column from the second row in the result set:
");
$result = $sth->fetchColumn(1);
print("colour = $result
");
?>
The above example will output:
Fetch the first column from the first row in the result set:
name = lemon
Fetch the second column from the second row in the result set:
colour = red
SEE ALSO
PDO.query(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDO.prepare(3), PDOStatement.setFetchMode(3).
PHP Documentation Group PDOSTATEMENT.FETCHCOLUMN(3)