Data Manipulation

Just a bin of macros and sql queries I use to manipulate data in excel or mysql


  1. Scan Top of Row Till End and return 3 columns
  2. Opposite of Lineemup
  3. Delete Rows When Second Column Is Blank
  4. Delete everything after certain character in quotes:
  5. Remove everything left of NTH character
  6. Remove everything left and right of middle
  7. Remove everything before
  8. Remove everything after
  9. Remove trailing characters
  10. Remove string contained in neighboring cell
  11. Remove first character if =”/”
  12. Remove last character if =”.”
  13. Bulk find and replace
  14. Caps and Lowe Case (proper)
  15. SQL query for category layout in opencart
  16. Remove all capital alpha
  17. Find OpenCart stock status differences
  18. Update OpenCart stock status based on imported table

Related Posts

Sublime Text 2 Commands to Simplify Your Life The following are shortkeys I use frequently to prevent carpal tunnel syndrome. A habit learned from playing Star Craft in high school. Who says video...
Adding a WordPress Blog to Your Rails App If you're running a rails application with a blog like I was, you we're probably using something that utilized jekyl. There are some good blogging pla...
Google Sheets Formulas Some google sheeets formulas to manipulate data in the cloud. Items will be added as I make use of new formulas. Index Split cell at a specif...

David Chun

I'm a full stack developer that builds tools for marketing and managing ecommerce shops. I occasionally consult for startups. If you've got an interesting project, reach out.


Leave a Reply

Your email address will not be published. Required fields are marked *