In excel hyperlink function, i want to get only url

for example, in cell,
=HYPERLINK(“WWW.GOOGLE.COM”, LINK)

how can I extract “WWW.GOOGLE.COM

2 Likes

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 : https://stackoverflow.com/questions/17152541/strip-string-after-or-before-certain-word-vb-net

I tried, but
I got the error message.


how could i solve this?

here you go with the xaml
hope its resolved
excel.zip (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 …

Regards
Balamurugan.S

1 Like