what I would like to do is compare the first five columns of each row to the entire records in the file and if there is a match, eliminate that record and print the matched five columns with the additional two columns.
Hi,
I have variables like mentioned below and want to separate as mentioned in output.
var1="4 x fibre cards"
var2="2 fibre cards"
var3="6 - fibre cards"
var4="4 x dual-port"
I have variables like this.I want to separate numbers from this and fibre cards from this.
output has to be... (4 Replies)
I have a file with the following data. I want to start writing lines out of this file to another file only after the time is greater than 20:00:00 hours and the first job is U1KC000. I would like to be able to run this out of a script and pass the time and job(U1KC000) as an argument.
... (14 Replies)
Hi friends,
My file is like:
Second file is :
I need to print the rows present in file one, but in order present in second file....I used
while read gh;do
awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile
done < secondfile
but the output I am... (14 Replies)
dear all,
i want elimination file with disk space for example:
$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
62G 19G 41G 31% /
/dev/sda1 99M 13M 82M 13% /boot
tmpfs 1014M 0... (2 Replies)
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Dear folks
I have a map file of around 54K lines and some of the values in the second column have the same value and I want to find them and delete all of the same values. I looked over duplicate commands but my case is not to keep one of the duplicate values. I want to remove all of the same... (4 Replies)
Hello there
I'd like to make a copy of 2nd column and have it printed in place of column 1. Remaining columns are needed as it.
test data:
ProbeSet GeneSymbol X22565285 X22566285
ILMN_1050008 MYOCD 6.577 7.395
ILMN_1050014 GPRC6A 6.595 6.668
ILMN_1050017 ... (2 Replies)
Example:
I have files in below format
file 1:
zxc,133,joe@example.com
cst,222,xyz@example1.com
File 2 Contains:
hxd
hcd
jws
zxc
cst
File 1 has 50000 lines and file 2 has around 30000 lines :
Expected Output has to be :
hxd
hcd
jws (5 Replies)
Discussion started by: TestPractice
5 Replies
LEARN ABOUT PHP
odbc_specialcolumns
ODBC_SPECIALCOLUMNS(3) 1 ODBC_SPECIALCOLUMNS(3)odbc_specialcolumns - Retrieves special columnsSYNOPSIS
resource odbc_specialcolumns (resource $connection_id, int $type, string $qualifier, string $owner, string $table, int $scope, int
$nullable)
DESCRIPTION
Retrieves either the optimal set of columns that uniquely identifies a row in the table, or columns that are automatically updated when
any value in the row is updated by a transaction.
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $type
- When the type argument is SQL_BEST_ROWID, odbc_specialcolumns(3) returns the column or columns that uniquely identify each row
in the table. When the type argument is SQL_ROWVER, odbc_specialcolumns(3) returns the column or columns in the specified table,
if any, that are automatically updated by the data source when any value in the row is updated by any transaction.
o $qualifier
- The qualifier.
o $owner
- The owner.
o $table
- The table.
o $scope
- The scope, which orders the result set.
o $nullable
- The nullable option.
RETURN VALUES
Returns an ODBC result identifier or FALSE on failure.
The result set has the following columns:
oSCOPE
oCOLUMN_NAME
oDATA_TYPE
oTYPE_NAME
oPRECISION
oLENGTH
oSCALE
oPSEUDO_COLUMN
PHP Documentation Group ODBC_SPECIALCOLUMNS(3)