Oliver Vecernik schrieb:
Hi again!The answer seems to be no. But after googeling a bit a found a wonderful Python module called csv at:
After investigating a little bit further my CSV import couldn't work because of following reasons:
1. CSV files are delimited with CR/LF
2. text fields are surrounded by double quotes
Is there a direct way to import such files into PostgreSQL?
http://www.object-craft.com.au/projects/csv/
A minimal script called 'csv2tab.py' for conversion to a tab delimited file could be:
#!/usr/bin/env python
import csv
import sys
def convert(file):
try:
f = open(file, 'r')
lines = f.readlines()
p = csv.parser()
for line in lines:
print '\t'.join(p.parse(line))
except:
print 'Error opening file!'
if __name__ == '__main__':
convert(sys.argv[1]);
Regards,
Oliver
--
VECERNIK Datenerfassungssysteme
A-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.aon.at/vecernik
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
