Java snippet and regex

[adjrock]

Hi all, I am trying to write a condition on a string when ever a character is found in the somewhere in the middle of a number, I want an action done, something like this:

if regexmatch($columnname$,“F[0-9]+”)
{
this = do this;
}
else this = $columnname$
return this
I’m trying to implement this using Java snippet, can anyone advise? Thanks

[armingrudd]

Hi,

This can be done easily in “Column Expressions” node.

E.g.
if (regexMatcher(column(“columnname”),“F[0-9]+”)){
0
}
else column(“columnname”)

Best,
Armin

[adjrock]

Thanks armingrudd, got it working