Member Avatar for danny00

All,
I have a giant notepad filewith lots of data.

I need to chop it up into appropriate records. They data always starts with 123XYZ e.g. the following would be the contents of this notepad file:

123XWZ
data1 data1
data1 data1
0000XYZ

123XWZ
data1 data1
data1 data1
0000ABC

123XWZ
data1 data1
data1 data1
0000DEF


I want to be able to create a 3 files (maybe more depenign upon how many reocords exist) from this data with names "0000####" from the appropriate data in them. Please advise I am very very new to VB.

Thank you

  • 2 Contributors
  • 1 Reply
  • 102 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by cometburn
Member Avatar for cometburn

does it have arrangement of data? i mean does this have its pattern? Like, (look below)

Name:
Address:
Telephone no:

if it has, then this wouldn't be a problem since you can use, .Readline property of the textstream. after reading each line, save it on the database(if this is what you like). Actually, I made something like this before. Can't find it! So, I'll just share the idea.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.