I have an exported text file that looks like this:

[Text file](https://i.stack.imgur.com/oDBjq.png)

So it is built up like a table and it is unicode encoded. I don't create the export file, so please don't tell me to use csv files.

I already have a mariadb database in place with with a table that contains the respective headers (ID, Name, ..).

My goal is to read the data from the text file and insert it correctly into the daatabase. I am using node js and would like to know what steps i need to follow in order to accomplish my goal.

Can is use this instruction [URL](https://know-thy-code.com/importing-csv-data-mysql/)? I already tried it this way but i think the unicode encoding caused some problems.