String manipulation - pull only last entry

Hi Knimers,

So, the issue I have is the following:

 

There is this string colmun "GlobalCompressionLevelValue"

Each cell has entries separated with comma (,) . How can I make it read and keep only the last entry.

For example, If "softCompression" is the last entry in every cell keep the row , if it is not filter the row out.

So, in the examples above, I would need to keep only the first row, since its last entry is "softcompression".

 

Many thanks for youi help!

Hi,

you can use a Row Filter node with a regular expression like the one below on your GlobalCompressionLevelValue column. This will filter out all rows that do not end with a SoftCompression= statement.

^.*SoftCompression=[0-9]+$

Cheers,
Marco.

Many thanks!