Read | delimitted text file and query database

Posted on 2012-09-11
Last Modified: 2012-09-17
I have a pipe(|) separated text file with many rows of data as in attachment. I need to read the text file and generate a query using first two values and query oracle database and see which records are not there in oracle database table( each row of the text field corresponds to each record in database).  I would like to treate 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
Question by:gudii9
    LVL 26

    Assisted Solution

    What code do you have so far?  This seems like something that you could do fairly easily, so I'm wondering if you have a specific question?
    LVL 19

    Accepted Solution

    Here's one way of approaching the file reading problem (attached). There wasn't enough information in your question to address the database select but it should be easy to see where to put that in the context of the code. This should work with Java 1.4+


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
    Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
    This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
    This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now