FMPRO-L Archives

January 2013, Week 4

FMPRO-L@LISTSERV.DARTMOUTH.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
parsing a date from a text field
From:
Nick Adams <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Fri, 25 Jan 2013 17:32:53 +0200
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (384 bytes) , text/html (3829 bytes) 
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

ATOM RSS1 RSS2