Columns of IDs or Any Text to a Comma List, Simplified. For OTM, ERPs and SQL.
“Users of OTM, SQL, and PL/SQL all spend time converting columns to lists. We do it so much we hardly realize how much time we spend on such menial tasks. Imagine what you could do over a three month project if you saved seven minutes a day. That is seven hours over the life of a typical three month project, just converting text from one form to another. It adds up. For business users, who have to work with multiple systems every day, the savings is even more significant.”Justin, Avalletta Owner, Creator of Column Jargon
How much is your time worth?
Instead of spending two or three minutes each time you get a list of IDs messing with the data in Excel, why not just paste once and be done? Well now you can with ease.
Instead of manually going line by line to add a domain and quotes around your XIDs, why not paste once and be done? Well now you can with ease.
Instead of trying to figure out how many spaces are between each item in your column and writing a fancy regular expression or Excel formula to clean them up, why not paste once and be done? Well now you can with ease.