How to manipulate data on a non-delimited text file?

Posted on 2005-04-21
Last Modified: 2010-04-23
I have a text file that is not delimited and I need to extract imformation from the file and place it in an sql database.
I am coding  using VB.Net.

Is their some way in .Net to count the characters, so I can use that returned value to help me extract the
values I need.

I am using ASP.NET/VB.NET

Question by:oshe127
    LVL 9

    Accepted Solution

    you can try using String.Substring function
    LVL 13

    Expert Comment

    These are normaly a good place to look into Regular Expressions  Very quick and effective way of deciphering and splitting alot of data.

    They seem kindof cryptic at first but are a valuable tool.

    LVL 16

    Expert Comment

    The jet provider (ODBC adapter) supports fixed width files through the use of a schema.ini file.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
    1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 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

    8 Experts available now in Live!

    Get 1:1 Help Now