Split/trim help

UI.Vision RPA General Discussion
1

I have this code snippet:

  "Command": "store",
  "Target": "${!COL1}",
  "Value": "!csvLine",

The value of !COL1 is in the format SKU #111-0627
I want to extract the numbers after the #
I have looked in the DOCs for info on the syntax for split and trim and have found nothing.

Thanks

2 
{
  "Name": "TEST",
  "CreationDate": "2022-3-8",
  "Commands": [
    {
      "Command": "store",
      "Target": "#111-0627",
      "Value": "TEST",
      "Description": ""
    },
    {
      "Command": "echo",
      "Target": "${TEST}",
      "Value": "red",
      "Description": ""
    },
    {
      "Command": "executeScript_Sandbox",
      "Target": "return ${TEST}.replace('#', '');",
      "Value": "TEST",
      "Description": ""
    },
    {
      "Command": "echo",
      "Target": "${TEST}",
      "Value": "green",
      "Description": ""
    }
  ]
}

image
image712×353 4.97 KB

1 Like
3

Perfect, just what I needed.
Thanks