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)
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)
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)
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)
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)
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)
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)
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
pg_fetch_all
PG_FETCH_ALL(3)PG_FETCH_ALL(3)pg_fetch_all - Fetches all rows from a result as an arraySYNOPSIS
array pg_fetch_all (resource $result)
DESCRIPTION pg_fetch_all(3) returns an array that contains all rows (records) in the result resource.
Note
This function sets NULL fields to the PHP NULL value.
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
RETURN VALUES
An array with all rows in the result. Each row is an array of field values indexed by field name.
FALSE is returned if there are no rows in the result, or on any other error.
EXAMPLES
Example #1
PostgreSQL fetch all
<?php
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
echo "An error occurred.
";
exit;
}
$result = pg_query($conn, "SELECT * FROM authors");
if (!$result) {
echo "An error occurred.
";
exit;
}
$arr = pg_fetch_all($result);
print_r($arr);
?>
The above example will output something similar to:
Array
(
[0] => Array
(
[id] => 1
[name] => Fred
)
[1] => Array
(
[id] => 2
[name] => Bob
)
)
SEE ALSO pg_fetch_row(3), pg_fetch_array(3), pg_fetch_object(3), pg_fetch_result(3).
PHP Documentation Group PG_FETCH_ALL(3)