Replace string

KNIME Analytics Platform
1

Hi Team,

Is there a way to replace the “<0.20**” as “U**”. I want the “<” to be replaced as “U” and remove the number and retain the “**”. Looks very tricky but please suggest.

Thanks,
Poornima

2

Hi @PoornimaRamesh you can use the String replacer node with the following formula:

replaceChars(replaceChars($column1$,“01234567890.”,"" ),"<",“U”)

just substitute the $column1$ with the appropriate name

3 Likes
3

Thanks so much, this is working great.

Regards,
Poornima

2 Likes
4

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.