Thank you all for your assistance. 

I am using FMP 11 Advanced.
There is only one comma and one dash in the text. The text before the comma and after the dash is of variable lengths.
The date is always formatted , xxx xx, xxxx -

I am going to try the solutions offered and I will let you know how I made out.


Nick

Nick Adams
Karystos, Greece





On Jan 26, 2013, at 1:00 AM, FMPRO-L automatic digest system <[log in to unmask]> wrote:

> Would someone be so kind as to give me a hand.
> I am an amateur and only use FMP for my own projects.
> 
> I am trying to parse the date out of a text field.
> 
> The text field contains something like this:
> some text, Nov 10, 2006 - some more text
> 
> The date is between a comma and a dash.
> 
> I have been trying various combinations of text functions but cannot get anything meaningful.