I have a table with hundreds of rows and columns where cells all contain text strings. I managed to do part of what I need with
GroupBy (hiliting, concatenate), however the output contains “, ?” substrings wherever the original cells are empty. I would like to get rid of these substrings.
As I could not find how to tweek
GroupBy to avoid the “, ?” substrings I thought of running a substring replacement on the generated output.
Basically any cell containing “alpha, beta, ?, ?” should be changed to “alpha, beta”.
A text editor on the CSV output file could obviously do it but I could not find a Knime node for this simple operation. Looks easy for a single column but I have hundreds of them.