Hi experts,
I have a the following awk command,
awk '{print $1}' /users/jon/list4.txt. The output is
123
787
888
...
...
I want to move the output to array using shell programming.
My shell is tcsh.
Is it possible to move to array using shell porg? I know its possible in... (14 Replies)
Hi,
I have a file
1:apple orange:one
2:banana:two
3:cherry:3
When I do awk -F: ' { print $2 } ' file
apple orange
banana
cherry
Now, when i redirect awk output to the file it has issue with strings
#!/bin/bash
FILEA=file
A=(`awk -F: ' { print $2 } ' $FILEA `)
echo ${A} (2 Replies)
So, here's a scenario that requires the same logic as what I'm working on: Suppose that you have a directory containing files named after users. For awk's purposes, the filename is a single field-- something parse-friendly, like john_smith. Now, let's say that I'd like to populate an array in... (2 Replies)
Hi all,
I have a script which produces a nice table but I want to sort it on column 3.
This is the output line in the script:
# Output
{ FS = ":";
format = "%11s %6s %-16s\n";
prinft "\n"
printf ( format, "Size","Count","Who" ) }
for (i in... (21 Replies)
I have been trying this a lot of different ways and haven't found too much online. Here's what I've got so far:
j=0
declare -a first
zero=(`cat $tmpfile`)
for i in "${zero}"
do
command $i >> "${first}"
... (4 Replies)
Have built this script, the output is what I needed, but NR 6 is omitted. Why? Is it an error? I am using Gawk.
'{nr=$2;f = $1} END{for (i=1;i<=f;i++) if (nr != i) print i, nr }' input1.csv >output1.csvinput1.csv
1 9
3 5
4 1
7 6
8 5
10 6
output1.csv > with the missing line number 6. 6 is... (5 Replies)
I need help to sort the output of an awk array
Example datadata="1 blue
2 green
3 blue
4 yellow
5 blue
6 red
7 yellow
8 red
9 yellow
10 yellow
11 green
12 orange
13 black"
My awk line to get output in one lineecho "$data" | awk ' {arr++; next} END { for (i in arr) { if(arr>1 )... (2 Replies)
I have awk command :
awk -F ' ' '{ print $NF }' log filename
And it gives the output as below:
06:00:00
parameters:
SDS
(2)
no
no
no
no
doc=4000000000).
information: (6 Replies)
#!/bin/bash
PH=(AD QD QC 5H 6C 8C 7D JH 3H 3S)
echo ${PH}
In the above array, how can I print to screen just the first 8 elements of ${PH} and have the last 2 elements print just below the first line starting underneath AD?
I need to do this in order to save terminal window spacing... (5 Replies)
Discussion started by: cogiz
5 Replies
LEARN ABOUT PHP
pg_fetch_all_columns
PG_FETCH_ALL_COLUMNS(3)PG_FETCH_ALL_COLUMNS(3)pg_fetch_all_columns - Fetches all rows in a particular result column as an arraySYNOPSIS
array pg_fetch_all_columns (resource $result, [int $column])
DESCRIPTION pg_fetch_all_columns(3) returns an array that contains all rows (records) in a particular column of 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).
o $column
- Column number, zero-based, to be retrieved from the result resource. Defaults to the first column if not specified.
RETURN VALUES
An array with all values in the result column.
FALSE is returned if $column is larger than the number of columns in the result, or on any other error.
EXAMPLES
Example #1
pg_fetch_all_columns(3) example
<?php
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
echo "An error occurred.
";
exit;
}
$result = pg_query($conn, "SELECT title, name, address FROM authors");
if (!$result) {
echo "An error occurred.
";
exit;
}
// Get an array of all author names
$arr = pg_fetch_all_columns($result, 1);
var_dump($arr);
?>
SEE ALSO pg_fetch_all(3).
PHP Documentation Group PG_FETCH_ALL_COLUMNS(3)