Cant read strings from CSV file correctly. Help!
Hello,
I have written a Windows application that, among other things, reads CSV files (actually tab-delimited).
I need to have some string values written within a CSV file that contains ONLY numerics. Is there a way to store those strings in the same file without having them read by a CSV reader? Is there a "comments" character in CSV files to tell the Microsoft Text File driver to ignore a specific line? I use an ODBCDataAdapter to connect the file to the Dataset.
P.S. It goes without saying but I use a "schema.ini" file to specify the CSV config values.
# 2 Re: Cant read strings from CSV file correctly. Help!
I don't think there is a possibility of adding comments in a CSV File. However, you can add the data in the specific columns and then when you are reading back the data ignore these columns. I am not sure if this will suit your needs or not.
# 3 Re: Cant read strings from CSV file correctly. Help!
I don't think there is somthing like that. My best guess is that you have to handle this yourself, maybe a second stream (NTFS only)?
S_M_A at 2007-11-9 11:36:00 >

# 4 Re: Cant read strings from CSV file correctly. Help!
Ah, I guess I'll have to improvise once more :) I'll figure it out somehow. Thanks anyway...