I have a pipe(|) separated text file with many rows of data. I need to parse the text file and generate a query and query oracle database and see which records are not there in database( each row of the text field corresponds to each record in database). Then I need to prepare missing List CSV file and email the user about the missing list values. I am treating whole text file as array object and individual rows as again small arrays with many values(could be string, numericals etc) separated by | symbol.
Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance