[resolved] tDelimitedInput ignore comma inside quotes

Four Stars

[resolved] tDelimitedInput ignore comma inside quotes

I have a delimited file that I am trying to input, however an issue I am having is that there are some strings included with a comma (,) inside quotes ("), for example
"234524","Testfile","Hello,World","4444"

Is there a way to tell talend to ignore the comma INSIDE quotes?
Seventeen Stars

Re: [resolved] tDelimitedInput ignore comma inside quotes

hi,

modified the cvs option like in the sccreenshoot to tell Talend how parse quoted string.

[statistics] connected
[trace] connecting to socket on port 5009
[trace] connected
234524|Testfile|Hello,World|4444
[statistics] disconnected

regards
laurent
Four Stars

Re: [resolved] tDelimitedInput ignore comma inside quotes

Laurent,

I am using the text enclosure option """ in my project, but I am still getting this problem.

-J
Seventeen Stars

Re: [resolved] tDelimitedInput ignore comma inside quotes

put your escape char => escaping nothing
in the text field aera you need to have just 2 double quote ("") and tree in text enclosure

laurent
Four Stars

Re: [resolved] tDelimitedInput ignore comma inside quotes

Here is a screenshot of my options. The delimited file is exactly what I showed in the original post.
Seventeen Stars

Re: [resolved] tDelimitedInput ignore comma inside quotes

hi jkrfs,

so i don't know Smiley Happy

What is your result ? use coma like a delimited caracter ?

++
Four Stars

Re: [resolved] tDelimitedInput ignore comma inside quotes

Laurent,

thanks for your help, it does in fact work the way we both have it set up. i found another issue that is causing the null pointer exception...

take care
-J

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog