I am loading concept data into an Oracle database from csv files downloaded from Athena. Most of the data has loaded successfully but there are about 10k records that failed to load. Most of the data that failed to load contains quotes embedded in the records
CONCEPT_ID ;CONCEPT_NAME ; DOMAIN_ID; VOCABULARY_ID ; CONCEPT_CLASS_ID ; STANDARD_CONCEPT ; CONCEPT_CODE ; VALID_START_DATE
; VALID_END_DATE ; INVALID_REASON
4.0491863E7 ; 'Linked to" reference set attribute’ ; Metadata ; SNOMED ; Model Comp ; ; 447257003 ; 20120131 ; 20991231
As you can see from the data, the concept_id is also formatted incorrectly but again, just for these 10k records. Is this a known issue or any recommendations on the easiest way to work around it? Is the data available as a txt file. Note, I am working in a windows environment.