You can use replace - we can replace the, inside a double quote using a regular expression: Later versions of SQL Server allow text delimiters to be defined, python has a csv module.
The best way to fix this is to use someone else's code to deal with CSV - but if we are careful you can do this yourself with regular expressions. Observe that the constituency name has a comma in it - BULK INSERT is interpreting this as a field delimiter.
(The error was reported on 105 but because we skipped row 1 the actual first problem is on 104) We load all the raw text into $ge1 - we plan to fix the data stage by stage. You can look at the data with a text editor or use powershell.
0 kommentar(er)
