tags:

views:

216

answers:

1
+1  Q: 

Why is the column name from a CSV file different than its DataTable?

Howdy,

I'm using an OleDbConnection, OleDbCommand, and OleDbDataReader to read a CSV file into a DataTable.

The CSV file uses the first row as a header row.

Some of the names in the header have non alphanumeric characters like ( _ . / ).

When the system creates the Column names it is transposing the . (period) character into a # (pound sign).

Why is this one character being changed and is there a way to stop the change, making the . (period) stay in the column name?

Thank you,
Keith

+1  A: 

It's replacing periods because they're metacharacters in SQL for specifying hierarchies. I don't believe it's at all advisable to try to preserve the period.

chaos  2009-07-06 18:04:16
So, would you advise sourceColumnName.Replace(".", "#"); instead of trying to preserve the period?
Keith Sirmons  2009-07-06 18:37:24
I'm unclear on why you would do that; isn't OLE doing it for you already?
chaos  2009-07-06 19:25:01
Here is an example: object data = datatable.Rows[rowIndex][sourceColumnName.Replace(".", "#")];
Keith Sirmons  2009-07-06 21:28:10

related questions

C# Exception Handling continue on error
Exporting tab-delimited files in SSRS 2005
How can I join a list into a string (caveat)?
When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
Looking for tool to generate random CSV data
csv api for java
in rails, how to return records as a csv file
Import *variable record length* CSV file using SSIS
asp.net Convert CSV string to string[]
What's the best way to extract table content from a group of HTML files?
How do I save each sheet in an Excel workbook to separate CSV files with a macro?
Program for working with large CSV Files
How do I best generate a CSV (comma-delimited text file) for download with ASP.NET?
SSIS: Adding a constant column value when doing a CSV to SQL conversion
Java code to import CSV into Access
Parsing XML using unix terminal
CSV (or sheet in XLS) to SQL create (and insert) statements with .Net?
Generate Insert SQL statements from a csv file
Split a string ignoring quoted sections
FileHelpers performance
CSV string handling
What is a good web-based Grid that accepts Excel clipboard data?
CSV File Imports in .Net
How to export data from SQL Server 2005 to MySQL
Converting CSV File to XML in Java