Split and use the prefix of specific strings

KNIME Analytics Platform
1

In a table a column has Alb(Ler 34dx), I want to extract only Alb in the column i.e prefix of Ler, so I want to put a condition if the columns has (Ler, Lhr,Lpr) values in the data , please extract their prefix.
I feel we can achieve this using Column expresssion or String Replacer node, but not quite sure how to achieve this. Can anyone help?

2

Hi @analytics_sharma,

This expression in String Manipulation will do the task:
regexReplace($column1$, "^(Ler|Lhr|Lpr).*", "$1")

:blush: