String Manipulation Exact Replace

[rparr009]

Hi,

With the String Manipulation Node I would like to only change an exact string. For instance,

RT → RTF
RTF → RTF

Right now when I use the string replace node I get this:

RT → RTF
RTF → RTFF

I understand why this is happening but cannot seem to figure out to fix.

Thanks,

[izaychik63]

Use

Rule Engine — NodePit

node with Replace Column option
$Group$ = “RT” => “RTF”
TRUE

[Daniel_Weikert]

With the String manipulation I could only think of a regex solution. I think @izaychik63 way is the way to go

[rparr009]

The problem here is that I have other values in this column so it replaces all of those values with a “?”

[izaychik63]

Sorry, try this
$Group$ = “RT” => “RTF”
TRUE => $Group$

[rparr009]

That worked great! Thank you!

Now could I use one node to perform this for multiple criteria?

For instance

“RT” => “RTF”
“GFS” => “DDS”

[izaychik63]

You need t add other criteria before the last line
$Group$ = “RT” => “RTF”
$Group$ = “GFS” => “DDS”

so on …

TRUE => $Group$

[ipazin]

Hi there!

replace() function has modifiers available and w is to make replacement only when whole word is found. However Rule Engine seems better suited cause you have multiple replacements.

Br,
Ivan