In excel hyperlink function, i want to get only url

for example, in cell,

how can I extract “WWW.GOOGLE.COM


yah by split method
like this
use READ CELL activity to get the output from this cell position as a string variable
named str_input
–then use a assign activity like this
str_output = Split(Split(str_input,“(”)(1).ToString,“)”)(0).ToString.Replace(“”“”,“”)

Cheers @leemini

Or you can use ‘Before-After’ string operations if the href(“link”),link) (the wrapper) is static.

Ref : Strip String after or before certain word - Stack Overflow

I tried, but
I got the error message.

how could i solve this?

here you go with the xaml
hope its resolved (16.3 KB)

kindly let know for any queries or clarification

Cheers @leemini

Hi @leemini,

This package has an activity called Get Hyperlink. It helps you …


1 Like