About
PhD Candidate,
2CI New & Emerging Media Fellow,
Department of Computer Science
Georgia State University
Email: ashrestha2 (at) student (dot) gsu (dot) edu
Converting date time in excel: annoying problem, simple solutions
It might be the case at times when you have a .csv file with date formatted as "October 27, 2003" and you want to change it to "yyyy-mm-dd" format. Or you have a file with 'yyyy-mm-dd' dates and you want to convert it into excel format to do calculations. I, like everybody else tried using Microsoft Excel to do it.
AutoIT scripts a powerhouse for Visual Basic/QBasic lovers
If you're thinking of writing a script in Windows, something comparable to bash like say which runs your compiled java files on click so that you don't have to open up a console and type in java name.class, AutoIT scripts might just be the tool for you. Its a pretty nifty tool which uses basic like syntax. I used it for writing launchers for the compiled codes when i was working as an intern. I really like the file handling and string processing abilities of it - reminds me of the good ol days when QBasic was still a big thing. Dont hesitate to try it out.
Pages
