Friday, July 16, 2010

Commands to create CSV file of contacts

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

No comments:

OK GOOGLE on Samsung Galaxy S7 doesn’t work

To make Ok Google detection work on Galaxy S7 (Galaxy series phones) we need to perform a couple of steps. 1. As long as Samsung S vo...