Hi,

Are you sure the date is ALWAYS in that format (i.e. Month name in full, 1-2 digit day number, comma, four digit year ?

If so the regex to identify the line with the date should be fairly simple - but then Tore's suggestion of pulling the rest via VFP probably makes sense.

(Tore: any reason for suggesting a cursor over ALINES() ?)

Best,
Viv

>July 12, 2007
>
>if i can find this I would be all set, because the name and address comes after it
>
>Peter
>
>>Hi,
>>
>>Not neccessarily impossible - though likely not to be easy.
>>
>>Are all the dates in the same format (or at least in a limited number of variations) ?
>>Is there always an address prior to the date?
>>
>>It might be possible to catch to majority.
>>Regards,
>>Viv
>>
>>>I guess it is not possible :-(
>>>I need to display it then and have the user highlight the name first and the address second...
>>>
>>>too bad
>>>
>>>Thanks anyway
>>>
>>>
>>>peter
>>>
>>>
>>>
>>>>>>>I need to get names and addresses out of hundreds of letters into a table
>>>>>>>
>>>>>>>I have a routine which steps through the directory oipens each letter gets the content
>>>>>>>and now what?
>>>>>>>
>>>>>>>name and address i not always in the same spot
>>>>>>>
>>>>>>>can I get
>>>>>>>a the date with a regular wexpression
>>>>>>>and the name and address with a regular expression?
>>>>>>>
>>>>>>>thnks
>>>>>>>
>>>>>>>
>>>>>>>Peter
>>>>>>
>>>>>>How you recognize which is address and which is name?
>>>>>Also it would be nice to get the date
>>>>
>>>>
>>>>Date?
>>>>What date?
>>>>
>>>>BTW I don't thing it is possible with RegExpression, just because I can't find a way to separate two strings. there is no pattern for them.
>>>>That is only mine opinion, no need to be true :-)
>>>>BTW how you separate blocks?