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:

Removing audio noise from a video

The basic steps are to extract the audio, remove noise, and then re-insert the noise-free audio back into the video wrapper. Step I: Ext...