Double quotes

[admin]

Another problem I have, is loading text files where the delimiter is a comma and all fields are placed between double quotes.

The data loads fine, but some fields already had quotes in them before the load file was created, so now Im sitting with to many quotes for some fields, eg.

""Bahamas"" (2 quotes at the start and 2 quotes at the end)


Datastage aborts as soon as it runs into a field like this. The error I get
is:
read_delimited() - invalid quotes, column City = ""

Does anyone have a suggestion on how to handle this ?
Dirk


Dirk Moolman
Database Administrator
Reach Technologies
South Africa

www.thefuelgroup.co.za

"No pessimist ever discovered the secret of the stars, or sailed to an uncharted land, or opened a new doorway for the human spirit." -Helen Keller




==========================================================
This message contains information intended for the perusal, and/or use (if so stated), by the stated addressee(s) only. The information is confidential and privileged. If you are not an intended recipient, do not peruse, use, disseminate, distribute, copy or in any manner rely upon the information contained in this message (directly or indirectly). The sender and/or the entity represented by the sender shall not be held accountable in the event that this prohibition is disregarded. If you receive this message in error, notify the sender immediately by e-mail, fax or telephone representations contained in this message, whether express or implied, are those of the sender only, unless that sender expressly states them to be the views or representations of an entity or person, who shall be named by the sender and who the sender shall state to represent. No liability shall otherwise attach to any other entity or person. ==========================================================