In excel hyperlink function, i want to get only url

[leemini (mimimimicee)]

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

how can I extract “WWW.GOOGLE.COM”

[Palaniyappan (Palaniyappan P)]

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

[Raghavendraprasad (Raghavendraprasad Bhat)]

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 vb.net - Stack Overflow

[leemini (mimimimicee)]

I tried, but
I got the error message.

how could i solve this?

[Palaniyappan (Palaniyappan P)]

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

kindly let know for any queries or clarification

Cheers @leemini

[balupad14 (Balamurugan)]

Hi @leemini,

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

UiPath Go ! BalaReva EasyExcel Activities

Hi , I have developed new activities called “Insert Hyperlink”, “Get Hyperlink” and “Remove Hyperlink”. Insert Hyperlink - Add hyperlink (display text and address) to the cell . Get Hyperlink - Get the address for the hyperlinked cell. Remove Hyperlink - Remove the hyperlink the the cell (It won’t delete display text) [image] Insert Hyperlink : [image] Get Hyperlink : [image] Remove(Delete) Hyperlink : [image] Note : Special thanks to @Gnaneshwari_Pinna . She gave the idea made …

Regards
Balamurugan.S