How to edit the clipboard value using automation anywhere

Question

1. I extract a value "10.1.1.0/27" from Excel sheet using get cell command, and storing in a system variable clipboard
2. Then I have to paste the value in another window page in the format like "10.1.1.0" by removing "/" and "digits after /"

I have done up to step 1 and guide me how to do the second step.

Answer 1

Solution for UiPath.

The easiest way would be to use the Split function of VB.Net.

Therefore, add a Assign activity. Create a new variable here called NewValue. Give it the following value:

"10.1.1.0/27".Split("/")(0)

Or you set 10.1.1.0/27 to a variable called InputValue

InputValue.Split("/")(0)

That command gives back 10.1.1.0 right into your variable NewValue