The first issue is that it is removing leading 0’s and I would like tit not to remove the leading 0’s since I need it for the file and site no’s
The second issue is when I have a row with multiline of data in my columns it is changing it and creating more rows and messing with my columns by not putting data into the right columns.
not sure but could it be that you are missing the \ before the u0000?
Or do you not indend to not select the characters outside the 0000-06FF unicode range?
Also your regex includes the newline character - so it always will remove them as well?
If you only want to select the unicode range at the end of the line (at least that is what you are currently doing) without removing the newline as well you can change your regex to:
else if you want to remove just any of these special characters anywhere in your string - then I would change the regex to:
Maybe you should test your string in a regex tester like:
there it is easier to see what is currently matched and why (as well as providing support on what regex syntax is availible I guess)
@ScottF not direcly related to this topic… but do you indend to upgrade the native knime regex nodes in the future?
They seem really really basic compared to @qqilihq nodes, so often it is easier to fall back to Java Snippets with regex
@sgilmour I think it depends on what you indend to do.
As it seems like you want to remove certain special unicode characters - I would think that you cannot use the extract node for that.
I think you can however use the Palladian Nodes to check your regex and see what you actually want change.
(however I still think my regex above should come near if I understood you correctly)
I think you c