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
