I'm getting lots of delimited files from Excel and MySQL users that,
mid-file, begin truncating lines if ending in null values.
for example:
1781: "one","two","three",,,,,,
1782: "one","two","three",,
1783: "one","two","three",,
(delimited files from Open Office are well behaved)
is there any way to handle this apparently standard aberration in PG?
____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel
and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
