I was thinking you might try @FORMAT
<@FORMAT STR="18:30:30 Jan 1, 2000 PST" FORMAT="datetime:%Y%m%d %H%M%
S" INFORMAT="datetime:%H:%M:%S %b %d, %Y PST" ENCODING="none">
Ben
On Aug 23, 2006, at 5:25 PM, William M Conlon wrote:
Thanks,
this is what I came up with. Ugly!
<@ASSIGN SCOPE="request" NAME="months" TYPE="array" VALUE="<@ARRAY
COLS='1' ROWS='12' VALUE='01;02;03;04;05;06;07;08;09;10;11;12'>">
<@ASSIGN scope="request" NAME="months[1,0]" VALUE="Jan">
<@ASSIGN scope="request" NAME="months[2,0]" VALUE="Feb">
<@ASSIGN scope="request" NAME="months[3,0]" VALUE="Mar">
<@ASSIGN scope="request" NAME="months[4,0]" VALUE="Apr">
<@ASSIGN scope="request" NAME="months[5,0]" VALUE="May">
<@ASSIGN scope="request" NAME="months[6,0]" VALUE="Jun">
<@ASSIGN scope="request" NAME="months[7,0]" VALUE="Jul">
<@ASSIGN scope="request" NAME="months[8,0]" VALUE="Aug">
<@ASSIGN scope="request" NAME="months[9,0]" VALUE="Sep">
<@ASSIGN scope="request" NAME="months[10,0]" VALUE="Oct">
<@ASSIGN scope="request" NAME="months[11,0]" VALUE="Nov">
<@ASSIGN scope="request" NAME="months[12,0]" VALUE="Dec">
<@ASSIGN SCOPE="request" NAME="pp" VALUE="<@TOKENIZE
VALUE='payment_date' CHARS=' :,'>" TYPE="ARRAY">
<@ASSIGN NAME="postargarray[payment_date,2]" VALUE="@@pp[1,6]@@months
[@@pp[1,4],1]@@pp[1,5]@@pp[1,1]@@pp[1,2]@@pp[1,3] ">
On Aug 23, 2006, at 4:50 PM, Robert Garcia wrote:
Well, this will seperate the elements...
expr="^(\d{2}):(\d{2}):(\d{2}) (\w+) (\d+), (\d+) (\w+)"
first match will be the 24hour hour, second the minutes, 3rd
seconds, 4th, the month as 3 letter abbrev, 5th, the date of month,
6th, the 4 digit year, and 7th, the time zone.
If you do this in witango, it will give an array, each row one of
the matches, then you can put in any format you want, you just have
to run the 3 digit month through a method, to change Jan to 1, Feb
to 2, etc.
Note, the regex above, assumes the hour, minute, will be padded 2
digits, if the timestamp can look like this 2:23:5 then change to:
expr="^(\d+):(\d+):(\d+) (\w+) (\d+), (\d+) (\w+)"
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Aug 23, 2006, at 4:02 PM, William M Conlon wrote:
18:30:30 Jan 1, 2000 PST
______________________________________________________________________
__ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Bill
William M. Conlon, P.E., Ph.D.
To the Point
345 California Avenue Suite 2
Palo Alto, CA 94306
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
