12-21-2016
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file with multiple records...and I have to select records based on first column....here is the sample file...
I01,abc,125,1a2,LBVI02
I01,abc,126,2b5,LBVI02
I02,20070530,254,abc,LLBI01
I02,20070820,111,bvd,NGBI01
I need all records with I01 in first field in one file and... (8 Replies)
Discussion started by: mgirinath
8 Replies
2. Shell Programming and Scripting
I have got a file like this
003ABC00281020091005000100042.810001 ... (8 Replies)
Discussion started by: Maruti
8 Replies
3. Shell Programming and Scripting
Problem,
How can you pass today's date (eg) 18 into Awk and select the field representing the 18th column?
I have an output that I want to interact with based on what day it is
information=0:0 192:0 5436:0 22:99 0:0 0:0 1234:0 1359:09
DAY=date'+%d'
numbrs=`$information | awk... (2 Replies)
Discussion started by: Gizmo1007
2 Replies
4. Shell Programming and Scripting
Hello,
I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2
SDF4 -0.211654
SDF4 0.978068
... (1 Reply)
Discussion started by: Diya123
1 Replies
5. Shell Programming and Scripting
My item was not answered on previous thread as code given did not work
I wanted to print records from file2 where comparing column 1 and 16 for both files find rows where column 16 in file 1 does not match column 16 in file 2
Here was CODE give to issue
~/unix.com$ cat f1... (0 Replies)
Discussion started by: sigh2010
0 Replies
6. Shell Programming and Scripting
I want records which have more than one and different value in the second column on the below sample file.
Ex, I have the samle file below :-
XYZ 1
XYZ 3
abc 1
abc 1
qwe 2
qwe 1
qwe 3
I want to select XYZ and QWE line only. (6 Replies)
Discussion started by: Sanjeev Yadav
6 Replies
7. UNIX for Dummies Questions & Answers
Hi experts, I have a tab-delimited file with one column containing values separated by a comma. I wish to duplicate the entire line for every value in that comma-delimited field.
For example:
$cat file
4444 4444 4444 4444
9990 2222,7777 6666 2222 ... (3 Replies)
Discussion started by: torchij
3 Replies
8. Shell Programming and Scripting
Hello everyone,
I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this:
20170628-23:25:01,1,0,0,1,1,1,1,55,55,1
20170628-23:30:01,1,0,0,1,1,1,1,56,56,1
20170628-23:35:00,1,0,0,1,1,2,1,57,57,2
20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Discussion started by: ejianu
6 Replies
9. Shell Programming and Scripting
Need your support for below. Please help to get required output
If column 5 is INV then only consider column1 and take out duplicates/identical rows/values from column1 and then put minimum value of column6 in column7 and put maximum value in column 8 and then need to do subtract values of... (7 Replies)
Discussion started by: as7951
7 Replies
LEARN ABOUT PHP
odbc_result
ODBC_RESULT(3) 1 ODBC_RESULT(3)
odbc_result - Get result data
SYNOPSIS
mixed odbc_result (resource $result_id, mixed $field)
DESCRIPTION
Get result data
PARAMETERS
o $result_id
- The ODBC resource.
o $field
- The field name being retrieved. It can either be an integer containing the column number of the field you want; or it can be a
string containing the name of the field.
RETURN VALUES
Returns the string contents of the field, FALSE on error, NULL for NULL data, or TRUE for binary data.
EXAMPLES
The first call to odbc_result(3) returns the value of the third field in the current record of the query result. The second function call
to odbc_result(3) returns the value of the field whose field name is "val" in the current record of the query result. An error occurs if a
column number parameter for a field is less than one or exceeds the number of columns (or fields) in the current record. Similarly, an
error occurs if a field with a name that is not one of the fieldnames of the table(s) that is(are) being queried.
Example #1
odbc_result(3) examples
<?php
$item_3 = odbc_result($Query_ID, 3);
$item_val = odbc_result($Query_ID, "val");
?>
NOTES
Field indices start from 1. Regarding the way binary or long column data is returned refer to odbc_binmode(3) and odbc_longreadlen(3).
PHP Documentation Group ODBC_RESULT(3)