Shell Programming and Scripting

#!/usr/bin/env python
import csv
reader = csv.reader(open("file.csv", "rb"))
for row in reader:
    print '|'.join(row)
    # do whatever you want with row here..

# python test.py
I|+2007|SANDA, 20, MARTIN PLACE|SANDA 20MARTIN
D|+2008|RANDA, 22, MARTIN PLACE|RANDA 22MARTIN

awk '{
        for (i = 1; i <= length($0); i++) {
                x = substr($0, i, 1)
                if (x == "\"") {
                        c++
                }
                if (x == "," && c % 2 == 0) {
                        x = "\t"
                }
                printf x
        }
        printf ORS
     }' sample.dat > sample.tsv

@fields = ();
while (m/"([^"\\]*(\\.[^"\\]*)*)",?|([^,]+),?|,/g) {
  push @fields, defined $1 ? $1 : $3
}
push @fields, undef if m/,$/;
# @ fields now contains parsed line of CSV