Hi,
I need to compare 2 files based on the first field in each file and output the differences to a new file.
example File 1 and File 2 both have first field as Number ie:
File 1
1252652355
1859553322
1778899562
File 2
1252652355
1859553322
So I would expect File 3 to... (2 Replies)
Hi Friends,
I have a requirement like i have two files in diffrent locations. i want to compare these two files, if both the files are same i want to return "0" else return 1.
Please help me on this.
Thanks
sreenu. (3 Replies)
how can i unix compare two files??
var1 = 6499 7328 6351 7583 7573
var2 = 6499 7328 6351 7583 7777
i did:
diff $var1 $var2
and i got the output:
1c1
< 6499 7328 6351 7583 7573
---
> 6499 7328 6351 7583 7777
what can i do with it? and what does it tell me?? how can i knoe that... (2 Replies)
I have two files which have primary key(s) for each row.
I need to compare both the files and produce the output in the following format.
Primary key(s),file1 value,file2 value.
Both the input files will be comma separated files.
I have accomplished this using perl, but it is... (6 Replies)
Hi Gurus
I need your kind help sorting the below query
I have two text files
File1.txt
ID Name Address
101 Srinath BBB
102 Sidharth CCC
File2.txt
ID Name Address
102 Siddharth DDD
103 Suman EEE
Now the requirement is if the second file has... (0 Replies)
Hi,
I have two files
File1 Contents:
abc
dcf
sdc
File2 Contents:
dcf
sdc
erg
Now my program should return the contents existing in File1 but not in File2. In this case output shoud be "abc" as abc is not available in File 2. It should not return "erg" by saying it is... (4 Replies)
Hello,
I have a dat file nctilllist.dat which will be present in the directory path
"/usr/lpp/web-data/mfg/nct/file-data/nctilllist.dat"
nctillist.dat will have reference to files like DP100001.jpg,DP10002.PDF,DP100003.doc
on the path /usr/lpp/web-data/mfg/nct/file-data will have... (12 Replies)
I have a file containing the below data obtained after running a diff command
> abc 10
< abc 15
> xyz 02
<xyz 05
.....
Does anyone know how i can obtain output like :
previous value of abc is 10 and present value is 15
similarly for all the comparisons in the text file (10 Replies)
I have requirement to compare two files in unix. Below are the sample files.
File1:
cn=test123,cn=bobgroup,dc=ind,dc=com
cn=bob123,cn=bobgroup,dc=ind,dc=com
cn=test13,cn=bobgroup,dc=ind,dc=com
cn=est12,cn=bobgroup,dc=ind,dc=com
cn=st123,cn=bobgroup,dc=ind,dc=com
File2... (1 Reply)
Hi,
I have below query related to multiple file comparing
I have four files i want to compare it and contents of one file will not be presence in 3other files and if any content found then it will print the execution.
Can you please help me how to achieve it. (2 Replies)
Discussion started by: soumyamihp
2 Replies
LEARN ABOUT PHP
mssql_field_seek
MSSQL_FIELD_SEEK(3)MSSQL_FIELD_SEEK(3)mssql_field_seek - Seeks to the specified field offsetSYNOPSIS
bool mssql_field_seek (resource $result, int $field_offset)
DESCRIPTION
Seeks to the specified field offset. If the next call to mssql_fetch_field(3) won't include a field offset, this field would be returned.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $field_offset
- The field offset, starts at 0.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Using mssql_field_seek(3) on the example for mssql_fetch_field(3)
<?php
// Connect to MSSQL and select the database
mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');
// Send a select query to MSSQL
$query = mssql_query('SELECT * FROM [php].[dbo].[persons]');
// Construct table
echo '<h3>Table structure for 'persons'</h3>';
echo '<table border="1">';
// Table header
echo '<thead>';
echo '<tr>';
echo '<td>Field name</td>';
echo '<td>Data type</td>';
echo '<td>Max length</td>';
echo '</tr>';
echo '</thead>';
// Dump all fields
echo '<tbody>';
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
// Fetch the field information, notice the
// field_offset parameter is not set. See
// the mssql_field_seek call below
$field = mssql_fetch_field($query);
// Print the row
echo '<tr>';
echo '<td>' . $field->name . '</td>';
echo '<td>' . strtoupper($field->type) . '</td>';
echo '<td>' . $field->max_length . '</td>';
echo '</tr>';
// Move the internal seek pointer to the next
// row in the result set
mssql_field_seek($query, $i + 1);
}
echo '</tbody>';
echo '</table>';
// Free the query result
mssql_free_result($query);
?>
SEE ALSO mssql_fetch_field(3).
PHP Documentation Group MSSQL_FIELD_SEEK(3)