I’m writing this short blog post to share with you a couple of different ways I manipulate multiple HTML tags I need to target for various reasons. Sublime Text is a fantastic editor but there is another editor from yesteryear I’ll cover as well…
sed
Data prepping with Sed for bulk uploads using the PostgreSQL COPY command.
This post will highlight usage of the PostgreSQL COPY command. Along the way, I will use Sed, a Unix command-line utility, to ‘massage’ sample data into a more uniformed structure. Once the data has been formatted to our requirement, we will then load it into a PostgreSQL table.