I'm guessing the text before and after the date could also include commas and dashes?
On 25 January 2013 15:32, Nick Adams <[email protected]> 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. > > > Nick > > Karystos, Greece > > > > > > -- [image: fourninety.com] Emma Glaisher - Artworker and Database Development 490 Global Ltd - fourninety.com <http://490ltd.co.uk/wp/>Tel: +44 113 238 2447 | [image: LinkedIn]<http://www.linkedin.com/company/490-global-limited>| [image: Twitter] <https://twitter.com/490Global> Nepshaw Lane South, Leeds, LS27 7JQ If you need to send me any large files (Over 3MB) please click here<http://filetransfer.fourninety.com/dropbox/~ROy5lj> . 490 Global Ltd is part of Basil Communications Pvt Ltd. Also part of Basil Communications Pvt Ltd - Basil Global - basilglobal.com<http://www.basilglobal.com> 490 Global Ltd may not be held responsible for the content of this email as it may reflect the personal view of the sender and not that of the company. Should you receive this email in error, please notify the sender immediately and do not disclose, copy or distribute it. While 490 Global Ltd scans all outbound emails for viruses, it cannot be held responsible for any infected files that you may receive. 490 Global Ltd advises all recipients to virus scan any file attachments. Registered address: Fourninety Global Ltd, 126-134 Baker Street, London, W1U 6UE. Registered Company Number: 07905241 [image: Recommended Agency]<http://www.recommendedagencies.com/profile/2266/> [image: ISO9001] <http://www.iso9001certification.co.uk/index.php>
