Results 1 to 2 of 2

Thread: Read a text file and search for ORDERID

  1. Oct 8th, 2014, 10:00 AM #1
    aspfun
    aspfun is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2010
    Posts
    478

    Read a text file and search for ORDERID

    I need to create a vb.net program to read a text file (c:\order\order.txt, about 60MB) and search any ORDERID starting ***.

    For example, text file look like

    hnwrouwowo***12345nxcnirwekrkweh***556699...

    Program need to select "12345", "556699"...and then insert into a SQL table.

    Can someone give me an idea?
    Reply With Quote Reply With Quote
  2. Oct 8th, 2014, 05:12 PM #2
    jmcilhinney
    jmcilhinney is online now
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,352

    Re: Read a text file and search for ORDERID

    So what you're saying is that you want to find any string of numeric digits that follow three asterisks, correct?
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW) | C# (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW)
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width