I am trying to parse the contents of a specific cell to make sure that
the cell contains only a date, or the text "F1", or "f1", or both, a
date -and- "F1" or "f1".
The "F1" language can sometimes be: F1,F2,F3

I'm sorry I don't have any code to post, I haven't gotten anything to
work yet.

Thanks in advance,
RC

On 18 Sep 2006 10:27:40 -0700, wrote:

I am trying to parse the contents of a specific cell to make sure that
the cell contains only a date, or the text "F1", or "f1", or both, a
date -and- "F1" or "f1".
The "F1" language can sometimes be: F1,F2,F3

I'm sorry I don't have any code to post, I haven't gotten anything to
work yet.

Thanks in advance,
RC

What is the precise format of the date?

Is it always a text string? Or might it also be an "Excel" date.

If the cell contains both a date and the text 'F1...' does the cell contain a
formula to produce that, or merely the string "some date string F1"


--ron

Please restate what is acceptable.

are you saying F and any number so that F1 symbolizes F and any single
digit number?

or are you saying the cell could actually contain all of "F1,F2,F3"

and if so, then how does that relate the 4 conditions you stated (of which
it matches none).

If it contains a date and more, will the date always be first.

--
Regards,
Tom Ogilvy



" wrote:

I am trying to parse the contents of a specific cell to make sure that
the cell contains only a date, or the text "F1", or "f1", or both, a
date -and- "F1" or "f1".
The "F1" language can sometimes be: F1,F2,F3

I'm sorry I don't have any code to post, I haven't gotten anything to
work yet.

Thanks in advance,
RC

I plan to format the cell with a date format, which works well if the
user enters only a date, but sometimes the users may need to enter a
footnote also. The data can look like:
12/25/06 or
12-25-06 or
12/15/06 F1 or
12/15/06 F1,F2,F3,F4,F5,F6 or
12-25-2006 f1,f2

etc.


Tom Ogilvy wrote:
Please restate what is acceptable.

are you saying F and any number so that F1 symbolizes F and any single
digit number?

or are you saying the cell could actually contain all of "F1,F2,F3"

and if so, then how does that relate the 4 conditions you stated (of which
it matches none).

If it contains a date and more, will the date always be first.

--
Regards,
Tom Ogilvy



" wrote:

I am trying to parse the contents of a specific cell to make sure that
the cell contains only a date, or the text "F1", or "f1", or both, a
date -and- "F1" or "f1".
The "F1" language can sometimes be: F1,F2,F3

I'm sorry I don't have any code to post, I haven't gotten anything to
work yet.

Thanks in advance,
RC

I'll let Ron give you a regular expressions solution since he will whether I
answer or not.

--
Regards,
Tom Ogilvy


" wrote:

I plan to format the cell with a date format, which works well if the
user enters only a date, but sometimes the users may need to enter a
footnote also. The data can look like:
12/25/06 or
12-25-06 or
12/15/06 F1 or
12/15/06 F1,F2,F3,F4,F5,F6 or
12-25-2006 f1,f2

etc.


Tom Ogilvy wrote:
Please restate what is acceptable.

are you saying F and any number so that F1 symbolizes F and any single
digit number?

or are you saying the cell could actually contain all of "F1,F2,F3"

and if so, then how does that relate the 4 conditions you stated (of which
it matches none).

If it contains a date and more, will the date always be first.

--
Regards,
Tom Ogilvy



" wrote:

I am trying to parse the contents of a specific cell to make sure that
the cell contains only a date, or the text "F1", or "f1", or both, a
date -and- "F1" or "f1".
The "F1" language can sometimes be: F1,F2,F3

I'm sorry I don't have any code to post, I haven't gotten anything to
work yet.

Thanks in advance,
RC

On Mon, 18 Sep 2006 12:28:01 -0700, Tom Ogilvy
wrote:

I'll let Ron give you a regular expressions solution since he will whether I
answer or not.

And I was hoping you'd answer with a non-regular expression solution :-)
--ron

Should I check the cell contents as a string and extact any text like,
f1 etc., and then check the remaining string with isdate?

Something like that maybe?

Ron Rosenfeld wrote:
On Mon, 18 Sep 2006 12:28:01 -0700, Tom Ogilvy
wrote:

I'll let Ron give you a regular expressions solution since he will whether I
answer or not.

And I was hoping you'd answer with a non-regular expression solution :-)
--ron