Split and use the prefix of specific strings

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?

Hi @analytics_sharma,

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



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