Hello! I’m new to Knime and have read a lot of topics here, most of them really helpful, which allowed me to create my very own functional workflow! So thanks in advance.
My current issue is: I have successfully extracted the data from a sharepoint list and created an excel file with the results, however, one of the columns contains an URL inside a lot of nonsense characters which appear to be coming from the Sharepoint list (the URL is correct in the list, i think the problem appears when it is imported in Knime).
If you want to keep it simple, then you can run the below 2 basic regex replace formulas in sequential column expression nodes. You have to escape the special characters, which makes it a bit less straightforward.
The 1st part of the formula that references the column doesn’t follow the correct syntax. Try deleting that part and inserting the column reference via the column selection at the top left of the formula area. The formulas I added above are also meant for the Column Expression node in case you were using them elsewhere.
If you are using it in String nodes, then I believe that you would need to remove 1 of each of the escape characters. So it would appear as
2 \ characters instead of 3 \ characters before the special characters.