CSV Input Files & # Of Commas Between The Quotes
We have been using stored procedures to load *.CSV files from the school district's FMS. In testing for our third link, we have found that when processing inbound data via an external table, a table will not import if there is more than one comma between the quote marks. If I segregate out the multiple comma field records, then the rest of the data will process just fine. Is this normal? Sample of offending records during the last test load:
MI,002958,20103031,WAREHOUSE,CT-105109,"010174 BASE, NOTIFIER, HEAT DETECTOR",15.82,02781
MI,002931,20100415,WAREHOUSE,A4-104706,"091470 FAUCET, SINGLE, METERING",76.56,02801
*********
MI,002958,20100331,WAREHOUSE,CT-104111,"010174 BASE, NOTIFIER, HEAT DETECTOR",47.46,02781MI,002958,20103031,WAREHOUSE,CT-105109,"010174 BASE, NOTIFIER, HEAT DETECTOR",15.82,02781
MI,002931,20100415,WAREHOUSE,A4-104706,"091470 FAUCET, SINGLE, METERING",76.56,02801
0