timevex

Hi, Does anyone know of a date time format conversion UDF? I'm looking to convert: mm/dd/yy hh:mm:ss AM/PM to yyyy-mm-dd hh:mm Wondering if anyone has a udf out there that does basic date time stamp format conversions. Thanks Tim

WeaponX, That is absolutely beautiful! I need to work with CSV's and tab separated files, Could you provide a regular expression string that will split on TAB's but not on double quoted TABs? Thank you! Tim

I have a large set of tab separated and comma separated files that I'd like import into an sqlite data base using sqlite.au3 however I'm having trouble splitting the fields correctly due to separators within double quoted text. example; Field1,"Field 2", Field3 12334,"Quoted Text","city,state" Does anyone know a clean method to do string split that ignores double quoted delimiters? Would replacing quoted delimiters with a temporary string via a regular expressions replace work? I'm horrible at regular expressions, would anyone be able to provide the regular expression syntax to replace delimiters inside double quotes? Example; String: (1234,"quoted text string","quoted string containing a delimiter, example") SearchString: any double quoted commas ReplaceString: "!+!" Output: (1234,"quoted text string","quoted string containing a delimiter!+! example") Thoughts? Thanks in advance! Tim

Great UDF! Very nice work... Having a problem getting delete mail working, constantly getting illegal parameter returned. Would you be able to tell me what I'm doing wrong? $MailArray = _OutlookGetMail($oOutlook,$olFolderInbox & "\TTDispatch",False,"","","","","","",True,"",0,False) If @error > 0 Then MsgBox(4096,"Get Mail Error",@error,600) _ArrayDisplay($MailArray) ;One unread email returned correctly, no issue... For $mailitem = 1 to (Ubound($MailArray)-1) $fromemail = $MailArray[$mailitem][1] $subject = $MailArray[$mailitem][7] $receivedtime = $MailArray[$mailitem][5] ConsoleWrite("Fromname = " & $fromemail & " Subject = " & $subject & " Received Time = " & $receivedtime & @CRLF) ;example of email parameters ;Fromname = /O=EMC/OU=NORTH AMERICA/CN=RECIPIENTS/CN=KASCHP ;Subject = INTRANSIT Re: EMC TriageTrac Dispatch: Barclays Capital SR# 31720334 ;Received Time = 20091010013225 $DeleteMessage = _OutlookDeleteMail($oOutlook,$olFolderInbox & "\TTDispatch",$fromemail,$subject,$receivedtime,False,False,"") If @error > 0 Then MsgBox(4096,"Delete Message Error",@error,600) Next I'm consistently getting illegal parameters regardless of what parameters are omitted. Do the (from email,subject or received) parameters require a different format than what is returned by get mail? Also, are you aware of any issues with intermittent missing of messages using get mail with the unread only option set to true? It seems to be missing some emails intermittently, it does still mark the messages read but doesn't return them in the array. This is why I'd prefer to delete each message processed rather than just marking it read. Thanks in advance for any advice you can offer. Tim

Getting this error after it reaches 100% of Read & Dither. >Running: C:\Program Files\AutoIt3\AutoIt3.exe /ErrorStdOut "C:\Documents and Settings\ehrnft\My Documents\scripts\ectach.au3" C:\Documents and Settings\ehrnft\My Documents\scripts\ectach.au3 (70) : ==> Variable used without being declared.: GUICtrlSetGraphic ($prevgraph, $GUI_GR_COLOR, 0xffffff) GUICtrlSetGraphic ($prevgraph, ^ ERROR Any ideas? Tim

Can anyone recommend a binary read method and binary TcpSend method? I'd like to add the ablity to serve image files but can't read the binary .jpg's. Thanks Tim

Using Larry's tcp_server script, I modified it to act as a simple html request server. It's working to serve html but I haven't figured out how to send images to the browser. Thinking about an autoit embeded web interface. Need to figure out how to send images and also need to build a POST receive function to handle form data from the browser. Work with 3.1.1.betas with tcp commands Thanks Tim html_server.au3