Manually Parsing a CSV file.

[stuartgmilton]

Hi folks,

I have a DTS job which imports a csv file overnight on a daily basis. Unfortunately, one of the columns has started to have double quotes entered into it, this causes the datapump to fail.

Does anyone know if it is possible to programatically run through the file adding a second double quote where necessary?

Any help would be appreciated.

Stu

 

[rac2]

comma comma is an empty numeric field
comma string comma is a numeric field with a value
comma quote quote comma is an empty string field
comma quote string quote comma is a string field with a value
comma quote string quote string quote comma is a bad field
therefore the enclosed quote should be replaced

comma quote string quote string ... quote string quote comma
requires multiple replacements for each enclosed quote

This could be a pre-process, how you would automate it or include it in the DTS package I dont know.

As to the replacement value, rather than "" for " I would use a back tick ` or possibly a character entity " because the quote mark is just going to cause more trouble.