# Table difference Finder - incorrect differences in column name identified **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [January 24, 2024, 1:58pm UTC](https://forum.knime.com/t/table-difference-finder-incorrect-differences-in-column-name-identified/76779 "2024-01-24T13:58:16Z")\ **Posts on this page:** 1\ **Showing post:** 6
**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\ **Post date:** [January 24, 2024, 7:17pm UTC](https://forum.knime.com/t/table-difference-finder-incorrect-differences-in-column-name-identified/76779/6 "2024-01-24T19:17:47Z")
OK, @taylorpeter55 , you have a Unicode non-breaking space character \u00A0 in one of the outputs at the point where you have a regular space (Unicode \u0020) in the other. I suspect this is there courtesy of Excel. This is between the words “Amount” and “Currency”. You can read the text downwards in the first column in each table. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/1/c18935655416978e01618488a2e5f5deb36ae00f.png) From the workflow, it looks like you are still on KNIME 4.7. There is a String Cleaner node in KNIME 5.2 but I don’t think that would help here, because you actually want to convert these into regular spaces rather than strip them out completely otherwise the column names still wouldn’t match. You can resolve this using String Replacer with the following config with the following regular expression to find all “space” characters `\p{Zs}` (put a single space in “Replacement Text”) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/d/8/d89af74c355026ff87cd71c0e817ff61b8be7168.png) and I would suggest doing this both for your **XML** column and the **empty\_a** column, just to be on the safe side. That’s all a bit of a faff, so I have wrapped the String Replacer into a component called Unicode Space Replace so you can make use of that instead if you wish: > **[Unicode Space Replace – takbb](https://hub.knime.com/takbb/spaces/Public/Components/Unicode%20Space%20Replace~13SqtWGfsGk4CnmK/current-state)** > > Replaces various Unicode "space" characters found in a String column with a regular space @takbb Brian Bates 24 Jan 2024 Place this (or String Replacer) in the workflow as shown here: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/3/b3f23479c8f73763d6edc52d620edc03a31ed2d8.png) * * * If you are interested in how I found the set of character codes for each item, this was done with a another couple of components: > **[Cell Character Splitter – takbb](https://hub.knime.com/takbb/spaces/Public/Components/Cell%20Character%20Splitter~80lrBY41P-3upyP5/current-state)** > > Split an input column into individual characters with a new column being created for each character. 27 April 2021 @takbb Brian Bates > **[Character ASCII and Unicode – takbb](https://hub.knime.com/takbb/spaces/Public/Components/Character%20ASCII%20and%20Unicode~uGG0OjLJD-Aj-2Vr/current-state)** > > Returns the ASCII and UNICODE for the first character in a chosen String column @takbb Brian Bates 24 Jan 2024 Filter out a SINGLE row of data to be inspected (it gets horrible if you try to apply this to more than a single row!) and string the two components as follows: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/a/1aa3ba86f8146ca4fd63d48b108e4f81c8bccd7d.png) Configure the Cell Character Splitter to split the column of interest into individual characters (one column per character), then transpose gives one character per row. Column Auto Type Cast makes it a String in case it has become “undetermined type”, and then the Character ASCII and Unicode component is configured to inspect the required column. This will give you the ASCII and UNICODE for each character in the String. --- _[View the full topic](https://forum.knime.com/t/table-difference-finder-incorrect-differences-in-column-name-identified/76779)._