Use excel function "=SUBSTITUTE" to change words from a site for others, in Kantu, is it possible?

Ui.Vision General Discussion
1

I work with online sales, each order is processed manually, I have to copy and paste some parts of the text into a spreadsheet, so that it is later converted into data.

My question: Is it possible to replace parts of the text on a page automatically?

My intention is to replace text on the site in codes, so I don’t need to manually convert the information later, it is already partially ready to copy.

See the examples:
In the first example, it is the model I use to work, it has some information.
In the second example, it is the model that I would like it to stay.

I don’t have much experience in programming, my idea would be to use the same concept that exists in the Google Sheets spreadsheet.

It would be something like this function:
=SUBSTITUTE(SUBSTITUTE(“300g of Best Cofeee”; “432”:wink: “Enter your delivery address in this field:”;"")

exemple kantu
exemple kantu783×976 67.1 KB

I still have doubts if this is the best strategy, I’m willing to make changes, any help is welcome.

~google translator

2 
{
  "Name": "aa",
  "CreationDate": "2022-11-25",
  "Commands": [
    {
      "Command": "comment",
      "Target": "//////////////",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "var list = [\n  {\n    name: \"hello world\",\n    id: 1\n  },\n  {\n    name: \"coffe\",\n    id: 10\n  },\n  {\n    name: \"facebook\",\n    id: 69\n  },\n  {\n    name: \"rice\",\n    id: 777\n  },\n  {\n    name: \"300g of Best Cofeee\",\n    id: 432\n  },\n  {\n    name: \"google\",\n    id: 444\n  }\n]\n\nreturn JSON.stringify(list);",
      "Value": "productList",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "300g of Best Cofeee",
      "Value": "product",
      "Description": ""
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "var product = ${product}\n\nvar list = JSON.parse(${productList})\n\nvar find;\n\nfor (var i = 0; i < list.length; i++) {\n  if(list[i].name === product) {\n    find = list[i].id\n    break\n  }\n}\n\nif(find === undefined){\n  find = \"Product id not found\"\n}\n\nreturn find\n",
      "Value": "productId",
      "Description": ""
    },
    {
      "Command": "echo",
      "Target": "${productId}",
      "Value": "green",
      "Description": ""
    },
    {
      "Command": "comment",
      "Target": "//////////////",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "Enter your delivery address in this field: fake address 123",
      "Value": "address",
      "Description": ""
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "return ${address}.replace('Enter your delivery address in this field:', '').trim()",
      "Value": "address2",
      "Description": ""
    },
    {
      "Command": "echo",
      "Target": "${address2}",
      "Value": "green",
      "Description": ""
    }
  ]
}

image
image703×295 7.98 KB

3

Thanks for answering me, your solution helped me.

I managed to find an alternative that made my job easier.
A Google Chrome extension that allows you to change/replace words easily.

“Word Replacer II | Extension Chrome”
https://chrome.google.com/webstore/detail/djakfbefalbkkdgnhkkdiihelkjdpbfh

This extension can be very useful for anyone planning to do something similar.

#SUBSTITUTE