topic Re: Read correctly a value which includes the file's delimiter in Talend Studio

Read correctly a value which includes the file's delimiter

DrGenious — Sat, 16 Nov 2024 00:52:40 GMT

Hi,

I have a column which suppose to take the value: hello, Ted

But because the delimiter of the file is "," it separates the sentence into two columns.

Thanks in advance.

Anonymous — Tue, 05 Jan 2021 05:43:32 GMT

Hello,

Are your data in Text enclosure with ""? Such as: "hello, Ted", Mary, Dan,

If so, you can handle simple using by enabling CSV option in basic setting of tFileInputDelimited.

Best regards

Sabrina

DrGenious — Tue, 05 Jan 2021 07:37:47 GMT

@Xiaodi Shi

Hello,

No It hasn't got " ". The only thing which can help is that I know which column has this value

Anonymous — Tue, 05 Jan 2021 07:46:50 GMT

Hello,

Could you please give us some sample content of your input data?

Best regards

Sabrina

DrGenious — Tue, 05 Jan 2021 07:50:13 GMT

@Xiaodi Shi

student,grades,home-office,2020-12-19, It is our honor, to have you,poetry

teacher,grades,home-office,2020-11-20, It is our honor, to have you,literature

student,grades,home-office,2020-11-25, It is our honor, to have you,mathematics

The sentence: It is our honor,to have you

should be in one column

hanghan — Wed, 06 Jan 2021 12:54:26 GMT

@thodoros kastrinos ,

The proper csv file is having the double quotes around the string where your string itself contains the delimeter.

student,grades,home-office,2020-12-19, "It is our honor, to have you",poetry

teacher,grades,home-office,2020-11-20, "It is our honor, to have you",literature

student,grades,home-office,2020-11-25, "It is our honor, to have you",mathematics

Please try to solve the incoming input data.

DrGenious — Thu, 07 Jan 2021 08:16:50 GMT

Hi @Hardik Anghan I can not modify the input data