You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2014-04-09 09:43:11

kiran.bhoknal
Member
29 posts

kiran.bhoknal said:

[resolved] Delimiter with in quates

I want to convert Delimited text file into oracle table. text file is a COMMA(,) separated delimited file but for some rows within quates  there is comma so column movement is happening for that row.

so can you give me solution so-that it should not consider that comma as a delimiter
mini_132028_rawdata.PNG

Offline

#2 2014-04-09 09:54:04

sanvaibhav
Member
1719 posts

sanvaibhav said:

Re: [resolved] Delimiter with in quates

Hi Kiran,

In file input component, enable CSV option checkbox. This would solve your problem.

Thanks
Vaibhav


Talend Certified Consultant

Offline

#3 2014-04-09 10:39:19

kiran.bhoknal
Member
29 posts

kiran.bhoknal said:

Re: [resolved] Delimiter with in quates

It's Working...

Thanx vaibhav.

Offline

#4 2016-05-12 17:40:22

andrew.tan
Member
18 posts

andrew.tan said:

Re: [resolved] Delimiter with in quates

Hi,
I am having the same issue.  The contents within the " " got split into 2 columns, column4 and column5 from the image, which not supposed to.


mini_test1.jpg mini_test2.jpg

Last edited by andrew.tan (2016-05-12 17:42:57)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy