Create Folder Recursively with Excel VBA January 31, 2021 How to: create folders recursively using VBA code in Excel. Read More
Open Explorer and select file in Excel VBA January 17, 2021 How to: open an Explorer window so a user can select a file in Excel VBA. Read More
SAS Remove Special Characters from String January 10, 2021 How to: check for, identify and remove non-alphanumeric characters when working with strings in SAS base code. About The below SAS code is one… Read More
Clear RAM (Garbage Collection) in Python January 1, 2021 Clear RAM usage at run time in Python with this function and optionally print the remining RAM usage. Helpful when executing code in loops… Read More
Postgres – List Tables Sizes November 22, 2020 How to: list table sizes in PostgreSQL Database using only SQL and built in PG functions. Read More
Convert Line Endings to Unix November 2, 2020 How to: convert line endings to UNIX with dos2unix command on your unix machine when importing data flat files. Read More
Netezza – Check for Special Characters October 26, 2020 How to: check for special characters or non-alphanumeric characters in a string when working with Netezza SQL. Read More