I have a word document, and i wish to extract the Hyperlinked text and the embedded hyperlink for the same text in an excel. How would i achieve that:
Word document file: “Please click here to go to
www.uipath.com”. The word “here” has an embedded hypelink for the website.
In the excel i need two columns. First column with the text (which is “here” is this case) and second column with the weblink (the embedded text)
Thanks in Advance
This link and the sample code provided doesn’t help much. It does give a way to pull the links, but only when they are preceded by http or https.
I am looking for extraction of hyperlinks and embedded links in a word file.
Need more Information
I believe the info needed is provided in the first point, where the issue is raised. Let me know what other information is required.
This is not helping. Let me try to give more information.
I have below three lines of text in a word doc.
Click here to access Google
Click here to access Microsoft
The words “here” are hyperlinks and have embedded links for google and microsoft
The workflow you provided shows only the last line as the result. However, what i need is an excel with all 3 hyperlinks and respective embedded links.
Hope this is more clear now.
Common UIpath Experts… Please get me an answer
Have a look on this post, you could given hyperlink onto your clipboard and use
System.Windows.Forms.Clipboard.GetText(System.Windows.Forms.TextDataFormat.html) Your hyperlink address will become exposed and you would be able to parse it using for example regex (many example on this on the Forum)
Could you have a look on this workflow based of GetClipboard Text & SetClipboard with RTF format?
RTF Stuff.xaml (6.0 KB)
You could also give a try with the HTML format from the clipboard (you need to change the RTF constants inside workflow.
To test it, just copy something in the clipboard with formating containing “test”, it should replace it with new values, preserving the format.
I guess the post bellow is about the same issue?