Import CSV - Comma problem

[innu]

Hi!

I import a csv-file and I have the following problem.

I have a numeric field, where the comma is ',' and not a '.' So if I want to import this file (MS-SQL), he says to me, that it isn't possible.

How can I substitute the ',' through '.'? Who can tell me?

 

[BakshG]

You can try to import data first into a staging table and then you can write a SP/SQL statement that makes use of "replace" function to clean up the data that contains "," with "." and then finally put that data back to the actual table.

 

[foxdev]

Ditto. That's also the approach I've had to use with data where there is embedded quote marks and/or, if using unquoted strings, embedded commas. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com