Parsing email data

[teeloo]

How can I parse the following data format that

[falkaholic]

Try something like this:

Middle( theField, Position(theField, "Name: ", 0,1), Position(theField, "<return charactor>",0,1))

that *should* work, and just repeat for the others.

[trevorg]

That is close to correct.

Here is what I made. It doesn't include the field names when parsing the data.

I only created it for Name: and Address:, but the rest could be modified easily.

Hope this helps! Definitely look up the Position function, and the Middle function.

Parse.zip

[teeloo]

Amazing! This works, but I am having trouble making the other scripts work for the other lines of data.

Which parameters need to be changed, and to what values?

[trevorg]

Feeling generous...

Here is the finished file.

Parse(Complete).zip

[teeloo]

Thanks Trevorg,

I do appreciate you completing the file for me, but i still would like to know HOW this parameters are affecting things. I am somewhat unclear as to how you are incorporating the Middle and the 2 Position functions together. Learning this would greatly help me in my neverending quest for knowledge -)

Give a man a fish and he'll eat it for a day -- teach a man to fish and he'll feed a town forever.

[trevorg]

I'll try my best to explain how it works.

First we need to understand the commands:

[color:"red"]Middle(text, start, size)

Parameters

text - any text expression or text field

start - any numeric expression or field containing a number

size - any numeric expression or field containing a number

[color:"green"]Position(text, search string, start, occurrence)

Parameters

text - any text expression or text field

search string - any text expression or text field representing the set of characters you want to find

start - any numeric expression or field containing a number, representing the number of characters from the start of the text string at which to begin the search

occurrence - any numeric expression or field containing a number. (A negative occurrence value causes the scan to go in the opposite direction from start. A zero value for occurrence is invalid and returns a result of zero.)

Lets take one of the Set Field Commands and break it down. This one is to set the City field.

Middle(TextChunk, Position( TextChunk, "