I have a table with multiple columns. I would like to change all “&” into “and” and all “,” into “;”.
So “Projects + Summary, comparison” will look like this “Projects and Summary; comparison”. Is there a faster way to do it than making this for all columns?
You can use nested functions to do all manipulations in one node. To do it for several columns, you could use the Column Expressions node or manipulate columns in a loop starting with the Column List Loop Start node and ending with the Loop End (Column Append) node. For the second approach you have to create the expression as a flow variable and pass it to the String Manipulation node.
If you need more help, provide me with a sample data set and I will send you a workflow example.
I cannot find this node (column expression) in my knime, I can see that I have to install an extension to do it. However I do not now which one is it. When I entered this link in browser, I couldn’t access it. In Knime, I couldn’t find this extencion.