While I primarily have been focusing on my current employment and freelance projects, I also have made incremental changes to existing packages/repos on my GitHub. In particular, I have renamed VBAops to XLops, which serves as the primary repo where I will write and maintain utility functions for Excel and VBA. Similarly, LBops contains similar modules for LibreOffice Basic/Calc.
Modules FunText: Functions for parsing text.
FunDates: Functions for parsing dates.
Introduction When creating syntax, one has to ask themselves about the naming scheme: should I make the functions short for typing efficiency, or long for increased readability? Ruby has the former benefit, but sometimes the methods can be difficult to remember (e.g. is it len or length? Is it swapcase or swap_case?), as there isn’t a consistent naming scheme–however, some functions have synonyms to help those from other programming languages learn Ruby faster (e.
1. Introduction In my current workplace at Leverage Retirement, Inc., I use Autoit to automate file management operations, such as copying files to archive directories and checking whether files exist for the morning processes. These operations involve the application of regular expressions to find out whether specific files match a given pattern (e.g. Deposit \d{4}-\d{2}-\d{2}, where \d{x} represents a number of x digits). While there are many string functions in AutoIt, most of them apply only to constants and not arrays.
1. Introduction I have been dabbling with the Ruby programming language for work purposes lately. Overall, I enjoy its concise, fun syntax and string methods such as .chomp to remove new-line characters–and I especially like the compactness of map. However, I believe that I have been too accustomed to R’s default property of functions being vectorized, as I initially had some trouble with handling arrays and employing string methods.