04-10-2016
Why is the column added to row 2 always filled with 0-0-0-0-0? Why aren't entries in that row set to 1 if the number in a given column in row 2 is not present in row 1? In the given example, why shouldn't the last field in the output for row 2 be 1-1-1-1-1?
Other than being an interesting puzzle, does this problem address some real-world issue?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to Print starting 3rd line until end of the file. Pls let me know the command.
Thanks in advance. (1 Reply)
Discussion started by: smc3
1 Replies
2. Shell Programming and Scripting
Hi Guys...
I am newbie to awk and would like a solution to probably one of the simple practical questions.
I have a test file that goes as:
1,2,3,4,5,6
7,2,3,8,7,6
9,3,5,6,7,3
8,3,1,1,1,1
4,4,2,2,2,2
I would like to know how AWK can get me the distinct values say for eg: on col2... (22 Replies)
Discussion started by: anduzzi
22 Replies
3. Ubuntu
Hello,
I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file.
For example:
File 1 has 1411 rows, I ignore how many columns it has (thousands)
File 2 has 311 rows, 1 column
Would like to... (7 Replies)
Discussion started by: sogi
7 Replies
4. UNIX for Advanced & Expert Users
Hello everyone,
I am writing a script to process data from the ATP world tour.
I have a file which contains:
t=540 y=2011 r=1 p=N409
t=540 y=2011 r=2 p=N409
t=540 y=2011 r=3 p=N409
t=540 y=2011 r=4 p=N409
t=520 y=2011 r=1 p=N409
t=520 y=2011 r=2 p=N409
t=520 y=2011 r=3 p=N409
The... (4 Replies)
Discussion started by: imahmoud
4 Replies
5. UNIX for Dummies Questions & Answers
I am a new user of Unix/Linux, so this question might be a bit simple!
I am trying to join two (very large) files that both have different # of cols and rows in each file.
I want to keep 'all' rows and 'all' cols from both files in the joint file, and the primary key variables are in the rows.... (1 Reply)
Discussion started by: BNasir
1 Replies
6. Shell Programming and Scripting
Hi guys
I have file A with Below Data
ABC123 X1 X2 X3
ABC123 Y1 Y33 Y4
ABC123 Z1 ZS2 ZL3
ABC234 P1 PP3 PP9
ABC234 Q1
ABC234 R1 P09 PO332 PO331 OKI12
..
..
..
Now I want file B as below
ABC123 X1 X2 X3;Y1 Y33 Y4;Z1 ZS2 ZL3
ABC234 P1 PP3 PP9;Q1;R1 P09 PO332 PO331 OKI12... (1 Reply)
Discussion started by: asavaliya
1 Replies
7. Shell Programming and Scripting
Hi,
Please help with this.
I have several excel files (with and .xlsx format) with 10-15 columns each.
They all have the same type of data but the columns are not ordered in the same way.
Here is a 3 column example. What I want to do add the alphabet
from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies
8. Shell Programming and Scripting
Hi. How can I read row number from one file and print that corresponding record present at that row in another file.
eg
file1
1
3
5
7
9
file2
11111
22222
33333
44444
55555
66666
77777
88888
99999 (3 Replies)
Discussion started by: Abhiraj Singh
3 Replies
9. Shell Programming and Scripting
I need help with extract/print lines till stop pattern. This needs to happen after every 3rd occurrence of start pattern and continue till end of file. Consider below is an example of the log file. my start pattern will be every 3rd occurrence of ERROR_FILE_NOT_FOUND and stop pattern will be... (5 Replies)
Discussion started by: NSS
5 Replies
10. Shell Programming and Scripting
Hi Gurus,
I have requirement to identify the records based on one column value.
the sample file as below:
ID AMT, AMT1
100,10, 2
100,20, 3
200,30, 0
200, 40, 0
300, 20, 2
300, 50, 2
400, 20, 1
400, 60, 0
for each ID, there 2 records, if any one record amt1 is 0, the in 4th col add... (5 Replies)
Discussion started by: ken6503
5 Replies
LEARN ABOUT PHP
pg_fetch_result
PG_FETCH_RESULT(3) PG_FETCH_RESULT(3)
pg_fetch_result - Returns values from a result resource
SYNOPSIS
string pg_fetch_result (resource $result, int $row, mixed $field)
DESCRIPTION
string pg_fetch_result (resource $result, mixed $field)
pg_fetch_result(3) returns the value of a particular row and field (column) in a PostgreSQL result resource.
Note
This function used to be called pg_result(3).
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
o $row
- Row number in result to fetch. Rows are numbered from 0 upwards. If omitted, next row is fetched.
o $field
- A string representing the name of the field (column) to fetch, otherwise an int representing the field number to fetch. Fields
are numbered from 0 upwards.
RETURN VALUES
Boolean is returned as "t" or "f". All other types, including arrays are returned as strings formatted in the same default PostgreSQL man-
ner that you would see in the psql program. Database NULL values are returned as NULL.
FALSE is returned if $row exceeds the number of rows in the set, or on any other error.
EXAMPLES
Example #1
pg_fetch_result(3) example
<?php
$db = pg_connect("dbname=users user=me") || die();
$res = pg_query($db, "SELECT 1 UNION ALL SELECT 2");
$val = pg_fetch_result($res, 1, 0);
echo "First field in the second row is: ", $val, "
";
?>
The above example will output:
First field in the second row is: 2
SEE ALSO
pg_query(3), pg_fetch_array(3).
PHP Documentation Group PG_FETCH_RESULT(3)