Read correctly a value which includes the file's delimiter

[DrGenious]

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]

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]

@Xiaodi Shi​ 

Hello,

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[DrGenious]

@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]

@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]

Hi @Hardik Anghan​  I can not modify the input data