String manipulation with ReGex

Hi, I have a column with variables A, C, G and S and would like to convert all but S into C, and I would like to use ReGex does anyone knows what would be the line?

Thanks,

Hi @sergiogarciagt

Is there any particular reason why you want to go down the RegEx route? This is a lot easier to manage with a Rule Engine node :wink: .

$column1$ = "S" => $column1$
TRUE => "C"

4 Likes

Thank you @ArjenEX , this worked great, I was thinking in regex in case I needed to change the variables, but had never used the rule engine before. Thanks again.

1 Like

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