Icon

kn_​forum_​47511_​excel_​strange_​characters

Strange Excel Characters? Invisible Unicode characters

Strange Excel Characters? Invisible Unicode characters

Strange Excel Characters? Invisible Unicode charactershttps://forum.knime.com/t/weird-character-appearing/47511/2?u=mlauber71 /data/DataToCheck.xlsxDataToCheck.tableDataToCheck.tableWalmart State Target State.txtregexReplace($$CURRENTCOLUMN$$, "[^a-zA-Z0-9 ]" , "")regexReplace($$CURRENTCOLUMN$$, "[^\\w\\d\\s.,!@#$%&*()=+~`-]","" )regexReplace($$CURRENTCOLUMN$$, "[\\u200E]" , "")https://unicode-table.com/en/200E/OklahomaOklahoma‎the two strings are not identical with the‎ Left-To-Right Mark (U+200E) being presentNode 12regexReplace($$CURRENTCOLUMN$$, "[^\\w\\d\\s.,!@#$%&*()=+~`-]","" )https://stackoverflow.com/questions/11505742/regex-to-remove-special-invisible-charactersNode 14is_equalis_equalNode 17 Excel Reader Table Writer Table Reader CSV Reader String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) Table Creator GroupBy GroupBy String Manipulation(Multi Column) GroupBy Rule Engine Rule Engine GroupBy Strange Excel Characters? Invisible Unicode charactershttps://forum.knime.com/t/weird-character-appearing/47511/2?u=mlauber71 /data/DataToCheck.xlsxDataToCheck.tableDataToCheck.tableWalmart State Target State.txtregexReplace($$CURRENTCOLUMN$$, "[^a-zA-Z0-9 ]" , "")regexReplace($$CURRENTCOLUMN$$, "[^\\w\\d\\s.,!@#$%&*()=+~`-]","" )regexReplace($$CURRENTCOLUMN$$, "[\\u200E]" , "")https://unicode-table.com/en/200E/OklahomaOklahoma‎the two strings are not identical with the‎ Left-To-Right Mark (U+200E) being presentNode 12regexReplace($$CURRENTCOLUMN$$, "[^\\w\\d\\s.,!@#$%&*()=+~`-]","" )https://stackoverflow.com/questions/11505742/regex-to-remove-special-invisible-charactersNode 14is_equalis_equalNode 17 Excel Reader Table Writer Table Reader CSV Reader String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) Table Creator GroupBy GroupBy String Manipulation(Multi Column) GroupBy Rule Engine Rule Engine GroupBy

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: m_lauber
Created at: 2022-09-23
On NodePit since: 2022-09-24
Last update: 2024-05-01
Created with KNIME version: v4.6.2
Tags: unicodeLeft-To-Right MarkU+200Einvisiblecharacters

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

Try NodePit Runner!