best design for parse

[gs]

let say I have to deal with various date format and I am give format string
from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming format
string
a) use two array and statically match
b) use regex to find the order

[Herfried K. Wagner [MVP]]

"gs" <[e-mail] lusschrieb:

let say I have to deal with various date format and I am give format
string from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming format
string

Maybe you are looking for 'DateTime.Parse Exact'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[GS]

thank you, I give that a shot Hopefully . it will take care most of what I
need, or at least make the rest easier. except one thing,

I am dealing with lines of string data (up to 300 lines) and the date fields
position may not be known before hand although for a given set of lines,
they stay in the same place 99.999 of the time except for the odd comments
which is not that critical;

"Herfried K. Wagner [MVP]" <hi************ ***@gmx.atwrote in message
news:eT******** ******@TK2MSFTN GP03.phx.gbl...

"gs" <[e-mail] lusschrieb:

let say I have to deal with various date format and I am give format
string from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming format
string

Maybe you are looking for 'DateTime.Parse Exact'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Cor Ligthert [MVP]]

GS,

Maybe can you avoid this in 2007 and all things like that as
DateTime.parseE xact, but have a look to the nicely by Microsoft inbuild
globalization and than the to that related ToString option.

Cor

"gs" <[e-mail] lusschreef in bericht
news:Ot******** ******@TK2MSFTN GP03.phx.gbl...

let say I have to deal with various date format and I am give format
string from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming format
string
a) use two array and statically match
b) use regex to find the order

[GS]

thank you, Cor.

However, I must be thick. I don't quite get the drift as with regard to
2007. are we talking about a new release of studio, .net frame work or just
the release or patch to come out in 2007.

how would that handle string date mixed with other data?

Actually the original source of the data is displayed html table placed in
clipboard. the objective to standardize the date string to yyyy-mm-dd and
then pass on to other components for processing and storage

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

GS,

Maybe can you avoid this in 2007 and all things like that as
DateTime.parseE xact, but have a look to the nicely by Microsoft inbuild
globalization and than the to that related ToString option.

Cor

"gs" <[e-mail] lusschreef in bericht
news:Ot******** ******@TK2MSFTN GP03.phx.gbl...

let say I have to deal with various date format and I am give format
string from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming format
string
a) use two array and statically match
b) use regex to find the order

[Cor Ligthert [MVP]]

GS,

I was thinking about writting that this was not in the case with webpages.
However windowforms is the default in this newsgroup, therefore please tell
this next time.

Cor

"GS" <gs************ **********@msne ws.Nomail.comsc hreef in bericht
news:OI******** *****@TK2MSFTNG P06.phx.gbl...

thank you, Cor.

However, I must be thick. I don't quite get the drift as with regard to
2007. are we talking about a new release of studio, .net frame work or
just
the release or patch to come out in 2007.

how would that handle string date mixed with other data?

Actually the original source of the data is displayed html table placed in
clipboard. the objective to standardize the date string to yyyy-mm-dd and
then pass on to other components for processing and storage

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

>GS,

Maybe can you avoid this in 2007 and all things like that as
DateTime.parse Exact, but have a look to the nicely by Microsoft inbuild
globalizatio n and than the to that related ToString option.

Cor

"gs" <[e-mail] lusschreef in bericht
news:Ot******* *******@TK2MSFT NGP03.phx.gbl.. .

let say I have to deal with various date format and I am give format
string from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming
format
string
a) use two array and statically match
b) use regex to find the order

[Stephany Young]

It is?

Newsgroup microsoft.publi c.dotnet.langua ges.vb provides a forum for
questions and general discussion of Visual Basic .NET.

Source:
http://msdn.microsoft.com/library/en...rogrammers.asp
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** *********@TK2MS FTNGP02.phx.gbl ...

GS,

I was thinking about writting that this was not in the case with webpages.
However windowforms is the default in this newsgroup, therefore please
tell this next time.

Cor

"GS" <gs************ **********@msne ws.Nomail.comsc hreef in bericht
news:OI******** *****@TK2MSFTNG P06.phx.gbl...

>thank you, Cor.

However, I must be thick. I don't quite get the drift as with regard to
2007. are we talking about a new release of studio, .net frame work or
just
the release or patch to come out in 2007.

how would that handle string date mixed with other data?

Actually the original source of the data is displayed html table placed
in
clipboard. the objective to standardize the date string to yyyy-mm-dd and
then pass on to other components for processing and storage

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******* *********@TK2MS FTNGP06.phx.gbl ...

>>GS,

Maybe can you avoid this in 2007 and all things like that as
DateTime.pars eExact, but have a look to the nicely by Microsoft inbuild
globalizati on and than the to that related ToString option.

Cor

"gs" <[e-mail] lusschreef in bericht
news:Ot****** ********@TK2MSF TNGP03.phx.gbl. ..
let say I have to deal with various date format and I am give format
string from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming
format
string
a) use two array and statically match
b) use regex to find the order

[GS]

the target is actually part of a windows .net application with winform that
embed webbrowser control.

I despite the clipboard source may well be in html table, but I can get the
text. the resulting text will have columns delimited by a couple of space
like characters

I am just in the designing stage to find the an easy to maintain approach
that will yield adequate performance on target PCs.

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** *********@TK2MS FTNGP02.phx.gbl ...

GS,

I was thinking about writting that this was not in the case with webpages.
However windowforms is the default in this newsgroup, therefore please

tell

this next time.

Cor

"GS" <gs************ **********@msne ws.Nomail.comsc hreef in bericht
news:OI******** *****@TK2MSFTNG P06.phx.gbl...

thank you, Cor.

However, I must be thick. I don't quite get the drift as with regard to
2007. are we talking about a new release of studio, .net frame work or
just
the release or patch to come out in 2007.

how would that handle string date mixed with other data?

Actually the original source of the data is displayed html table placed

in

clipboard. the objective to standardize the date string to yyyy-mm-dd

and

then pass on to other components for processing and storage

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

GS,

Maybe can you avoid this in 2007 and all things like that as
DateTime.parseE xact, but have a look to the nicely by Microsoft inbuild
globalization and than the to that related ToString option.

Cor

"gs" <[e-mail] lusschreef in bericht
news:Ot******** ******@TK2MSFTN GP03.phx.gbl...
let say I have to deal with various date format and I am give format
string from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming
format
string
a) use two array and statically match
b) use regex to find the order

[GS]

thanks for all pitched in so far.

let give it another shot.

looks like an easier way out would be
1.copy the date format string regex string holder and then derive the
relevant regex expression to be used for date normalization later in part 2:
replace the regex string the yyyy to regex year expression with year
identifier
look for yy and replace with 20yy and repeat the step above
replace mmm with the month regex expression associated with month
identifier
replace mm with the 2 digit month regex expression associated with month
identifier
replace dd with the 2 digit day regix expression assoc. with day
identifier

2. use the resulting regex in regex replace to normalize to yyyy--mm-dd
any problem with the above approach?

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

GS,

Maybe can you avoid this in 2007 and all things like that as
DateTime.parseE xact, but have a look to the nicely by Microsoft inbuild
globalization and than the to that related ToString option.

Cor

"gs" <[e-mail] lusschreef in bericht
news:Ot******** ******@TK2MSFTN GP03.phx.gbl...

let say I have to deal with various date format and I am give format
string from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming format
string
a) use two array and statically match
b) use regex to find the order

[Cor Ligthert [MVP]]

Stephany,

You would have seen (you are not a newbie) how much time it took especially
for me, before I got it accepted that the used VB.net language in ASPNET was
also a part of the language and not of the framework and therefore suspect
of this newsgroup. Maybe you even saw that last week I wrote that again in
the C# newsgroup.

I only ask to the OP to tell that if it is specialized on a webpage (what
seems to be not the case) to tell that. Most of the persons answering here
are taking windowsforms as default, and in the case of date times I seldom
ask that, because there is "leiter" no DateTime Value equivalent in HTML.

Cor

"Stephany Young" <noone@localhos tschreef in bericht
news:ut******** ******@TK2MSFTN GP03.phx.gbl...

It is?

Newsgroup microsoft.publi c.dotnet.langua ges.vb provides a forum for
questions and general discussion of Visual Basic .NET.

Source:
http://msdn.microsoft.com/library/en...rogrammers.asp
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** *********@TK2MS FTNGP02.phx.gbl ...

>GS,

I was thinking about writting that this was not in the case with
webpages. However windowforms is the default in this newsgroup, therefore
please tell this next time.

Cor

"GS" <gs************ **********@msne ws.Nomail.comsc hreef in bericht
news:OI******* ******@TK2MSFTN GP06.phx.gbl...

>>thank you, Cor.

However, I must be thick. I don't quite get the drift as with regard to
2007. are we talking about a new release of studio, .net frame work or
just
the release or patch to come out in 2007.

how would that handle string date mixed with other data?

Actually the original source of the data is displayed html table placed
in
clipboard. the objective to standardize the date string to yyyy-mm-dd
and
then pass on to other components for processing and storage

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2****** **********@TK2M SFTNGP06.phx.gb l...
GS,

Maybe can you avoid this in 2007 and all things like that as
DateTime.par seExact, but have a look to the nicely by Microsoft inbuild
globalizatio n and than the to that related ToString option.

Cor

"gs" <[e-mail] lusschreef in bericht
news:Ot***** *********@TK2MS FTNGP03.phx.gbl ...
let say I have to deal with various date format and I am give format
string from one of the following
dd/mm/yyyy
mm/dd/yyyy
dd/mmm/yyyy
mmm/dd/yyyy
dd/mm/yy
mm/dd/yy
dd/mmm/yy
mmm/dd/yy
dd/mm
what is the best way to come up a relevant regex for the incoming
format
string
a) use two array and statically match
b) use regex to find the order