Icon

String Replacer - RegEx Dollar Sign interpreted as end of cell nto end of line

There has been no title set for this workflow's metadata.

There has been no description set for this workflow's metadata.

Use CaseWhen reading data, i.e. PDF files via Tika Parser, the dataoften contain line breaks. Though, these are not desired to getused as that semi structured data requires pre-processing (i.e.split into rows at specific points).IssueUsing the String Replacer a custom delimiter, i.e. "$DELI$",can be inserted into desired locations. However, when using"$" representing the end of line, the String Replacer fails."$" is interpreted by the node as and of cell confirmed by themost bottom nodeForum Posthttps://forum.knime.com/t/string-replace-on-regex-match-interpreted-as-and-of-cell-but-not-end-of-line/73422 Splitinto listWORKSInsert $DELI$w/o "$" End of LineFAILSSplitinto listInsert $DELI$with "$" End of LineCONFIRMATIONInsert $DELI$with "$" End of CellCell Splitter Ungroup String Replacer Create simpletest data Ungroup Cell Splitter String Replacer String Replacer Use CaseWhen reading data, i.e. PDF files via Tika Parser, the dataoften contain line breaks. Though, these are not desired to getused as that semi structured data requires pre-processing (i.e.split into rows at specific points).IssueUsing the String Replacer a custom delimiter, i.e. "$DELI$",can be inserted into desired locations. However, when using"$" representing the end of line, the String Replacer fails."$" is interpreted by the node as and of cell confirmed by themost bottom nodeForum Posthttps://forum.knime.com/t/string-replace-on-regex-match-interpreted-as-and-of-cell-but-not-end-of-line/73422 Splitinto listWORKSInsert $DELI$w/o "$" End of LineFAILSSplitinto listInsert $DELI$with "$" End of LineCONFIRMATIONInsert $DELI$with "$" End of CellCell Splitter Ungroup String Replacer Create simpletest data Ungroup Cell Splitter String Replacer String Replacer

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Mike Wiegand
Created at: 2023-10-11
On NodePit since: 2023-10-12
Last update: 2024-05-01
Created with KNIME version: v5.1.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!