XLSX, SQL and CSV

data_manipulation.md

When working on automation workflow, it's often easier to work with CSV format because it's easy to use and easy to parse.

you can export xlsx file to csv too and play around with it.

for example you have line-separated data like

username;password;email
reakl yuki;qwerty;[email protected]

you can filter to just show the email only: sed '1d' | awk -F';' '{print $3}' filename > manipulated.txt

and if you perform batch update on your database, make sure to use transaction if possible, in order to make the operation safety.

reference:

• mariadb.com about CSV on mariadb