String manipulation with ReGex

[sergiogarciagt]

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,

[ArjenEX]

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 .

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

[sergiogarciagt]

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.