I want to import from a csv file with a bulk insert.
BULK INSERT ...
FIELDTERMINATOR = '~', --CSV field delimiter
ROWTERMINATOR = '\n', --Use to shift the control to next row
It works many times, but I have a problem I cannot solve.
If there is a field in my table, that is declared (for example) as decimal, there is a problem, because in the csv file the number is 1.234,5 and not 1234.5
Is it possible to replace in a column all data automaticly?
To code: remove in colum 3 the dot and replace the comma with a dot