Re: Witango-Talk: Paypal payment_date regex

[Robert Garcia]

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