| Compare Contents of two Text Files using Oracle [message #312496] |
Wed, 09 April 2008 01:07  |
|
|
I have to compare the contents of two text files and then write the common results to a new text file.
Suppose i have a file A with a pipe(|) delimited data, and file B with only one column of data. Now i want to compare the first delimited data field in file A with the Data in file B and for the common fields add the complete row from file A to a new file C.
e.g File A: QWERTY|T|14128989
MOR |M|98123456
& so on....
File B: TWRYUQ
& so on..
Now we need to compare the first delimited field QWERTY with the data in file B i.e. TWRYUQ and in case of similarity, write the complete row (QWERTY|T|14128989) from file A to file C.
NOTE: I want to automate this algorithm since it has to be used everyday.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
