ASCII delimited files

Al Christians achrist at easystreet.com
Thu Nov 11 05:16:48 CET 1999


There's a trick with files of delimited fields.  If a string field
contains a delimiter (e.g. a comma in a csv file), then the field
gets enclosed in quotes.  The handling of quotes is probably trickier,
IDK what the rules are if a field starts with or contains a single or
double quote mark.  I think I remember that some spreadsheets used tp
routinely enclose all strings in quotes in CSV files, but I'm not sure.

What I usually wind up doing to circumvent these problems with delimited
files is loading them back into a spreadsheet, typically the same one
that wrote them (I suppose that a database program would 
offer the same option), and then I write them out as tab-delimited. 
Tabs within fields are just about never in a lifetime in my work, so
far. 


Al


"Thomas A. Bryan" wrote:
> 
> "Thomas A. Bryan" wrote:
> 
> > class DelimParserField:
> >     def __init__(self, name):
> >         self.name = name
> >     def convert(self,value):
> >         return value
> >     def verify(self,value):
> >         pass
> >
> 
> One important thing that I didn't point out.  The "name" member
> is the column's name.  (Remember that I was thinking of
> delimited files for import into a database when I wrote these
> classes.)
> 
> Thus, a more sensible application might have something like
> employeeListParser = DelimFldParser((EnumField('Department',('HR','IT')),
>                                      DelimParserField('Name'),
>                                      NumericRngField('Salary',0,500000)))
> 
> If anyone uses this stuff, I'd be interested in hearing about it.
> 
> ---Tom




More information about the Python-list mailing list