You are not logged in.
i just have Talend Open Studio and i have no such wizard. (at least i haven't found one)
Here are images of my test job in TOS.
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?
So if I understand, your problem is that "United Corporate Services, Inc." gets cut into two?
I tried it and if I check the "CSV Options" checkbox and type """ and """ in "escape char" and "text enclosure" fields it works.
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.
On the advanced settings tab of the tFileInputDelimited you can check the Split row before field checkbox, this should probably fix your issue.
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:
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