executeScript_Sandbox Javascript replace exact match

Ui.Vision HowTo
1

Hi @Plankton @Timo @thecoder2012 @ulrich

I use a javascript to replace but this javascript NOT replace the exact match word i need the replacement exact word.

With this javascript if i have AAAHOME it replace in BBBHOME

I need only replacement if the value is AAA replace in BBB

In this case this javascript must NOT replace nothing because there are not exact match

My macro code

{
  "Name": "ZZZ Replace_Multiple",
  "CreationDate": "2020-2-11",
  "Commands": [
    {
      "Command": "store",
      "Target": "AAAHELLOBBB",
      "Value": "MyVar"
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "var mystring = ${MyVar}; var replaced = mystring.replace(/AAA/g, \"ZZZ\").replace(/BBB/g, \"TTT\"); return replaced",
      "Value": "MyNewvar"
    },
    {
      "Command": "echo",
      "Target": "${MyNewVar}",
      "Value": ""
    }
  ]
}

Log

[status]

Playing macro ZZZ Replace_Multiple

[info]

Executing: | store | AAAHELLOBBB | MyVar |

[info]

Executing: | executeScript_Sandbox | var mystring = ${MyVar}; var replaced = mystring.replace(/AAA/g, “ZZZ”).replace(/BBB/g, “TTT”); return replaced | MyNewvar |

[info]

Executing: | echo | ${MyNewVar} | |

[echo]

ZZZHELLOTTT

[info]

Macro completed (Runtime 1.17s)

Thanks to all

2

Hmm, if you only have a few cases, a simple conditional can help. So (in pseudo code notation)

  • if var = “AAA” then var = “BBB”.
  • if var = “ZZZ” then var = “TTT”.

So no “replace” command required, only “if” command used.

The other option is to use replace with regular expressions e. g.

3

Hi thanks for reply, my problem is that I have a large amount of words to replace and change periodically I need an integrated jaascript solution.

Can you help me to edit this code to replace only exact match word please ?

I know little javascript

    {
      "Command": "store",
      "Target": "AAAHELLOBBB",
      "Value": "MyVar"
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "var mystring = ${MyVar}; var replaced = mystring.replace(/AAA/g, \"ZZZ\").replace(/BBB/g, \"TTT\"); return replaced",
      "Value": "MyNewvar"
    },

Thanks

4

I wish I could help more, but regular expressions are not my strength :roll_eyes:

This answer seems to do what you need, but I have not tested it: Javascript replace exact match string - Stack Overflow

5

Thanks I try to edit javascript code reading the example and try to adapt the code.

Thanks

6

If you use the above string replacement code in RPA for Firefox you get:

[error] Line 2: E501: [Firefox only] executeScript_Sandbox does not support regular expressions.

Here is my solution for it. Instead of regex I use for {..} loop to do the character replacement. This “non regex” version runs in both, Chrome and Firefox.

{
  "Name": "replace string",
  "CreationDate": "2024-6-6",
  "Commands": [
    {
      "Command": "store",
      "Target": "123&,45 ; :xx67:89",
      "Value": "s",
      "Description": "Task: Remove all non numeric characters from this string"
    },
    {
      "Command": "echo",
      "Target": "String=${s}",
      "Value": "blue",
      "Description": ""
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "var inputString=${s};\nvar numericString = '';\nfor (var i = 0; i < inputString.length; i++) {\n    var char = inputString.charAt(i);\n    if (char >= '0' && char <= '9') {\n        numericString += char;\n    }\n}\nreturn numericString;",
      "Value": "n",
      "Description": "E501 workaround: Replace chars without using regular expression, so it works in Firefox, too"
    },
    {
      "Command": "echo",
      "Target": "Number=${n}",
      "Value": "green",
      "Description": "Clean string"
    }
  ]
}
1 Like
7

Thanks @Plankton the solution working like a charms :smiley: