How to convert empty string to null while reading CSV records?

Question

I am reading CSV files and dynamically creating database tables based on headers of CSV files.

But getting problem while reading csv data and dumping in to relevant tables. The problem comes when I have a column with decimal datatype and CSV fields contains blank so it is treated as string and getting below error.

Error :

Failed to convert parameter value from a String to a Decimal.

I am using CSV Helper and through class map, maybe I can achieve this but I am dynamically creating structure based on CSV files so I can't define any fixed class.

Here is 1 answer I found which might be helpful in case of class map: Using CsvHelper can I translate white space to a nullable?

Sample Record :

Problem occurs when sqlbulk copy tries to dump those data in SQL Server database table.

Community · Accepted Answer · 2017-05-23 12:33:45Z

1

I think that you might need to do column mapping. If you are using SqlBulkCopy you can use some of what is described on this post:

Mapping columns in a DataTable to a SQL table with SqlBulkCopy

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Dec 28, 2016 at 14:42

NicoRiff

4,8933 gold badges29 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I Love Stackoverflow Over a year ago

I have already done column mappings and when i insert data in those blank records then i dont get any error

Collectives™ on Stack Overflow

How to convert empty string to null while reading CSV records?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related