Paragraphs in Table View and Word

Dear friends, recently there was a complex question about paragraphs in PDFs, mine is much simpler, but likely of interest to beginners.

After collecting the data from the Internet, in the table view I see text formatted with paragraphs, like in the sample below.
изображение
Table viewer node doesn’t see these paragraphs and shows the text in a single block.
изображение
The same is with copy & paste from the table view to Word. Same is with BIRT reports.

BUT google translate sees these paragraphs if I copy the text at the web interface for translation.

Question: what character I should search for to replace with \n, or <p>, etc. to preserve these paragraphs in Table View and Word?

Thank you very much!

Hi @DmitryIvanov76,

The only way to show paragraphs on the table view is to format the text in the cell using HTML syntax. You need to either surround the paragraphs with <p>…<\p> or use the <br> tag where there should be a line break.

what character I should search for to replace with \n, or <p>, etc. to preserve these paragraphs in Table View and Word?

It is hard to tell without looking at the text first. Can you share an example workflow with sample data?

Best,
Temesgen

2 Likes

Thank you!

Copy & Paste to Knime also shows these paragraphs :slight_smile:

January 30, 2021

In this video, Leif Schauser, Director Product Management, QIAGEN Digital Insights will give you an overview of QIAGEN CLC version 21. Topics covered are

•Sanger sequencing workflows

•SARS-CoV-2 workflows

•BaseSpace access

•The Loss-of-heterozygosity caller

•The Haplotype caller

•Single-cell RNA-seq analysis

•The Genomics Analysis Portal to the QIAGEN CLC Genomics Server

1 Like

And the funniest thing that copy&paste of the cell to the text file gives even 2(!) paragraphs, but I still can’t get the code :frowning:

May be if worded this way the question will be simpler:

I need to know line separator in default table viewer of KNIME. Then I will replace it with <p> or \n and get the result - the structure of the text will be preserved.

And finally, the easiest solution was the best.

Simple String Replace node with “replace($Text$), “\n”,"<p>”)" worked.

1 Like

Cool! Great that you found a working solution.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.