Cleaning a CSV file from HTML tags

[knimerin]

Hi,
I want to read a csv file (tab seperated) but the file reader fails due to HTML tags inside a text-field. The HTML tags are only in a few text-fields of the 250 lines. Is it possible to scrap it anyhow during reading or any other workaround?

Edit: Maybe the problem is caused (I am currently not sure if this is the only problem) by two HTML tags (a closing a new beggining tag):

which have a not visible char maybe a tabulator or a return between the two >< . Is it possible to remove it from the reader?

Edit2: I attached a test file which shows the problem.

test.txt (1.7 KB)

[mlauber71]

You could try to use Readr R package to read more complex CSV files

Error with File Reader node while running in a loop

I had a similar problem where there were some ‘dirty’ CSV files out of a large number of files and they were too large to just ‘edit’ them in Notepad++ (and that also was not a very nice process). I built a workflow using the R package readr, which seems to me more tolerant towards problematic CSV files and gives you some control how to handle mismatching quotes and so on. You might have to toy around with the settings of the read_delim function. [46] kn_example_import_csv_r_readr.knwf (52.…