Parse a Text File

[athomas42]

textfile content:

From: webmaster@###.com
Sent: Thursday, May 24, 2007 2:25 PM
To: Webmaster
Subject: ####.com Contact us email

####.COM Contact us email notification

Name:##### #####
Title:Recruiter
Company:##### ######
Address1:#### #### ####
Address2:
City:##### #####
State:######
Zip:#####
Phone:###-###-####
Fax:
Email:ljones@###.net
eNewsletter:No
Question/Comments:Hello my name is John Doe and I represent etc.

I need to take this file in the format that it is in and go line by line and parse the data and put it in a sql db. Any help will be appreciated

 

[giadich]

1. Read the file line by line
2. Search for the ":" and copy the text behind it into a variable.
3. Once you've got all the variables/fields, write to the db.

You might want to trim the result to get rid of the leading and trailing spaces.

 

[athomas42]

Question:

Don't mean to be a pain but you wouldn't happen to have an example would you

 

[cjard]

textfile content:


I need to take this file in the format that it is in and go line by line and parse the data and put it in a sql db. Any help will be appreciated

I wrote a class that would do this.. using a set of carefully constructed regualr expressions, it can convert any text file, on the fly, into a dataset xml, which can be easily read in and sent to a database

 

[athomas42]

Quote:

I wrote a class that would do this.. using a set of carefully constructed regualr expressions, it can convert any text file, on the fly, into a dataset xml, which can be easily read in and sent to a database

Do you have an example of it

 

[giadich]

athomas,

I hope you know how to read the text file by now... if not, please visit my blog page... there's one or two blog dealing with text file.

As for parsing the data, here's a little code fragment:

Dim sSample as string = "Name: value"
Dim sValue as string
sValue = mid(sSample, instr(sSample, ":", comparemethod.text ))
[code]

Make sure you use intellisense to check the code as i wrote it off the top of my head.

 

[athomas42]

LOL...Yeah I knew how to read the file just had trouble parsing it....Thamx for the help though

 

[giadich]

I've got a couple other similar questions in msdn forums also and decided to do a blog about it... here ya go.

http://brian-dao.blogspot.com/2007/05/parsing-text-file.html

 

[cjard]

Do you have an example of it

Do you know regular expressions?