Parse text file

[Ruegen]

I want to parse through a text file - each fourth line there tends to be an email which I would like to divide (maybe into an array) to feed it into a row in a table

so email:john@john.com would be the last line and then it would create a new row.




I could use the return line to detect the end of the email too.

what functions would I use and what loops?

[June7]

Are you positive email will always be on 4th line?

Every fourth line:

For i = 1 to 4
If i = 4 Then
'parse the line and save to table
End If
'get next line
Next

[Ruegen]

Are you positive email will always be on 4th line?

Every fourth line:

For i = 1 to 4
If i = 4 Then
'parse the line and save to table
End If
'get next line
Next

Skipping the original quest now as I have converted the source which was a html page of div's, converted them to table tags and then imported them to excel (and in turn Access.

My next problem is along the same situation though. It's not separate rows - it's one long string, all the data is line after line - no columns or something I can parse using a regular parse editor.

I have memo fields on each record - I want to split up each memo field into a new table of rows and use text fields instead (of 255)

so I will have to cycle through each record memo, stuff it into a string, make a record in the new table (probably using a left() function of 255), remove it from the string after it is added, repeat the process until the string is empty (while at the same time stuffing the ID of each record belonging to the memo into the new table).

then after that move to the next record and memo field. I keep getting corrupted database records because we use a memo field - hence I want to do all this.

In the future when someone enters text on the record they will be creating a new record in the new table on the form (and I will time stamp and date stamp each new entry).
I can't get my head around as to how to chop a string up as I go.

hoping you can help.

[recyan]

Do not know the situation at your end. All the same,
Long time back, had to do something similar.
I directly copied ( select required portion on the web page & copy-paste) the HTML page ( not the source ) in to Excel & then I could find a pattern for manipulation & getting the required emailID's.

Edit : Is this a one time operation or will the database have to get this operation done on an automated basis regularly?

Thanks

[orange]

I recommend you supply a sample of
a)some existing records
b)the same data in the desired output format.

[Ruegen]

Something along the lines of

dim strNewRow as string, strMemo as string
dim lngMemoLength as long

do until fieldXYZ= ""

for i = 0  in strNewrow do 

strNewRpw = left(strMemo,255)
strMemo = Mid(strMemo, len(strMemo) - len(strnewrpw), len(strMemo))
'insert new row and push strMemo to field

next
loop

where it continues to chop the string down to 0 text and making rows with every 255 characters