I am trying to replace just some characters inside Excel cells. The reason is a strange encoding or something like that gives me troubles.
I guess the most similar post I have found here in the forum is Finding and replacing part of a string but the solution there is too simple for my needs.
I’ll try to explain what I need showing an example. Some rows of my Excel file are as follow (Italian language):
and I’d like to have a table as follows
What I’ve done
I have tried with the String Replace (Dictionary) node but it’s not working as I would like. I believe this is because the node is looking for whole strings instead of looking for single characters inside strings.
Just to be clear, the dictionary I want to use for these replacements has got 256 rows and many characters should be escaped in the case I’d try a regex.
Hope someone has an idea about how to solve this. Thanks in advance.