A BULK INSERT is made from a CSV file as seen below:
BULK INSERT [bdc_sync_L].[dbo].[Libro_bibliografia]
FROM 'D:\Data Center\Archivos\PRUEBA.csv'
WITH(FIELDTERMINATOR = '|', ROWTERMINATOR = '\n')
The problem is that a record has the following in the title:
"Science | Environment | Health"
At the moment of executing the INSERT , it marks an error because the data is disconnected.
Is there a way to make those 3 fields be taken as 1 only? And if not, can that record be ignored from SQL?
This is the complete record that marks error:
9789400793798 | "Science | Environment | Health" | Towards a Renewed Pedagogy for Science Education | Zeyer, Albert | Springer Netherlands
I do not want to delete the CSV record since there are many records, it will continue to populate and there is a possibility that similar records are added