Terminal commands to create CSV file of contacts out of list of names and phone numbers from website.
The idea is to copy paste the file list from the website onto a openoffice spreadsheet document. now save it as a CSV file.
Now, use the following commands in terminal (to remove the unnecessary whitespaces.).
cat a2.csv | sed 's/ //g' | sed 's/\" /\"/g' | sed 's/ \"/\"/g' > contacts.csv
The idea is to copy paste the file list from the website onto a openoffice spreadsheet document. now save it as a CSV file.
Now, use the following commands in terminal (to remove the unnecessary whitespaces.).
cat a2.csv | sed 's/ //g' | sed 's/\" /\"/g' | sed 's/ \"/\"/g' > contacts.csv
Comments