how to export data to txt format?

[natanzi]

Dear Knime experties,
I have 30M data and for a reason I should get export as a txt format instaed of csv, I could not find any node in knime, Is there any idea to get this format in export node?

BR,
Milad

[mlauber71]

How about you use the CSV writer and change the extension to .txt

CSV Writer (deprecated)

You could adapt the separator:

You could also adapt the encoding

And since we are at it - you can change the standard encoding in KNIME:

Migrate Cyrillic Database

Have you tried to use a simple example? Information in Russian characters stored in a KNIME table and then try to insert that into the MySQL database? In your screenshot I can see HTML code. Question is if the connector behaves in a different way if HTML is involved. There was a thread some time ago where @thor suggested to add a line to the knime.ini. But there was no mentioning of a solution for the problem. Also the DB in question was MySQL. -Dfile.encoding=UTF-8

[natanzi]

Thanks, I got it.

BR,
Milad