VBA Selenium - Copy part of element text and paste in another field

[adinev]

Hi all ,

I am trying to copy part of an element text and paste it in another element ,in its search box. The element contains a a policy number that i need to check in another system and it looks like this

60.22.9591 / RANDOM VENDOR NAME​

I need to get the numbers before the "/" and remove the dots before pasting . Any help will be appreciated.

Here is what i have so far:

Dim pause1, pause2, url As String
 
 pause1 = "00:00:08"
 
 pause2 = "00:00:30"

 url = "http://abv/"

Dim driver As New WebDriver

Dim rowc, cc, columnC As Integer

Dim tblent As Variant

Dim By As selenium.By

Set By = New selenium.By

driver.Get url

Application.Wait Now + TimeValue(pause1)

driver.FindElementByXPath("/html/body/div[2]/div[1]/ul/li[5]/ul/li[4]/a/span").SendKeys "c"

driver.Get url2

driver.FindElementByXPath("/html/body/l/li[5]/ul/li[4]/a/span").SendKeys "v"

Application.Wait Now + TimeValue(pause1)

driver.FindElementByXPath("/html/body/l/li[5]/ul/li[4]/a/box").Click

Application.Wait Now + TimeValue(pause1)

 

[iggydarsa]

Sub CleanPolicy()
    Dim pol As String: pol = "60.22.9591 / RANDOM VENDOR NAME"
    pol = Replace(Trim(Left(pol, InStr(1, pol, "/") - 1)), ".", "")
    MsgBox pol
End Sub

 

[adinev]

Sub CleanPolicy()
    Dim pol As String: pol = "60.22.9591 / RANDOM VENDOR NAME"
    pol = Replace(Trim(Left(pol, InStr(1, pol, "/") - 1)), ".", "")
    MsgBox pol
End Sub

Hi iggy. Do you have any idea how to solve the first part of the task . I realized, I phrased the question incorrectly so it seems that I am having issues only with the converting of the policy number. Thanks.