Thanks for the reply Sebastian, yes the problem is that "United Corporate Services, Inc" is cut in two. I've tried again and am still unable to get the data into the correct fields.

Is there a way to attach screen shots? I'm using the New Delimited File wizard and am on step 3 of 4. Is there is another way to load the file?

Regards,

Greg

Thanks for the reply but that doesn't appear to work. Within the Escape Char Settings I can either choose CSV or Delimited. If CSV is selected then the Escape Char and Text Enclosure are available but Split row before field is greyed out. If I select Delimited then only Split row before field is available.
Selecting Delimited and ticking the Split row before field check box returns the same data in the Preview pane as selecting CSV.

Regards,

Greg

I'm trying to load a CSV file into Data Integration (5.0.2.r78327) and the commas which appear within fields are causing some of the rows to be spread over extra fields. The fields with commas are enclosed in double quotes (") but selecting this option at step 3 of 4 doesn't make a difference to the Preview.

Here is the top of the file:

ID,LEGAL_NAME,TRADING_STATUS,REG_AGENT_NAME,REG_PO_BOX,REG_FLOOR,REG_BUILDING,REG_STREET_1,REG_STREET_2,REG_STREET_3,REG_CITY,REG_STATE,REG_COUNTRY,REG_POSTCODE
1,The Royal Bank of Scotland N.V.,Active,,,,,Gustav Mahlerlaan 350,,,Amsterdam,Noord Holland,Netherlands,1082 ME
2,AIG Financial Products Corp,Active,"United Corporate Services, Inc.",,,,874 Walker Road,Suite C,,Dover,DE,United States,19904
3,Allianz Vie S.A.,Active,,,,,87 Rue De Richelieu,,,Paris,Paris,France,75002

The REG_AGENT_NAME value for ID 2 contains a comma and this throws the data into a 14th column