ฟอรัมเทคนิค » Office applications »
RegEx or macro to modify hyperlinks
เธรดต่อผู้เขียนข้อความ: DZiW (X)
DZiW (X)
DZiW (X)
ยูเครน
ภาษาอังกฤษ เป็น ภาษารัสเซีย
+ ...
Jun 24, 2018

Is there's a safe way in Word 2013 or WFC to change hyperlinks in the text like
XXXX
to
XXXX (some-hyperlink)
?

TY

[Edited at 2018-06-24 21:48 GMT]
 
CafeTran Trainer
CafeTran Trainer
เนเธอร์แลนด์
สมาชิก (2006)
Safe Jun 25, 2018

DZiW wrote:

Is there's a safe way in Word 2013 or WFC to change hyperlinks in the text like
XXXX
to
XXXX (some-hyperlink)
?

TY

[Edited at 2018-06-24 21:48 GMT]


Are you referring to the conversion of a selected string or the conversion of a specified pattern (via a regex search)?
 
DZiW (X)
DZiW (X)
ยูเครน
ภาษาอังกฤษ เป็น ภาษารัสเซีย
+ ...
TOPIC STARTER
any Jun 25, 2018

Hello Hans,

It's about a conversion of the pattern: find all hyperlinks and replace with the text followed by hyperlinks in the brackets.

Why, RegEx seems quite versatile, but how?
 
Samuel Murray
Samuel Murray  Identity Verified
เนเธอร์แลนด์
Local time: 08:40
สมาชิก (2006)
ภาษาอังกฤษ เป็น ภาษาอาฟริกา
+ ...
Visually, maybe (but visually only) Jun 25, 2018

DZiW wrote:
Is there's a safe way...


The solution at answer #1 here gets you there halfway:
https://stackoverflow.com/questions/28335564/change-display-text-of-all-hyperlinks-in-document

Then, you can use Find/Replace to change the font of the text that you don't want to be a hyperlink, so that it doesn't *look* like a hyperlink. The part that you don't want to be a hyperlink will still be a hyperlink, but it won't look like one.

So, first use this macro:

Sub UpdateDocLinks()
Dim link As Hyperlink
For Each link In ActiveDocument.Hyperlinks
link.TextToDisplay = "{{{" & link.TextToDisplay & " (}}}" & link.Address & "{{{)}}}"
Next link
End Sub

And then use this find/replace with wildcards:
Find: (\{\{\{)(*)(\}\}\})
Replace: \2
and set the style of the Replace field as e.g. Default Paragraph Font.

----------------------------------------------

1.

two

2.

(then run macro)

3.

three

4.

four

5.

five



[Edited at 2018-06-25 12:29 GMT]
 
CafeTran Trainer
CafeTran Trainer
เนเธอร์แลนด์
สมาชิก (2006)
— Jun 28, 2018

—

[Edited at 2018-06-28 21:56 GMT]
 
Samuel Murray
Samuel Murray  Identity Verified
เนเธอร์แลนด์
Local time: 08:40
สมาชิก (2006)
ภาษาอังกฤษ เป็น ภาษาอาฟริกา
+ ...
@Hans Jun 28, 2018

Hans Lenting wrote:
The macro in this thread (I've tested the macro with Word:mac 16.14.1) converts [a plaintext URL] to a hyperlink...


I thought Dziw wanted the opposite -- convert a hyperlink into text.
 
CafeTran Trainer
CafeTran Trainer
เนเธอร์แลนด์
สมาชิก (2006)
You’re right Jun 28, 2018

Samuel Murray wrote:

Hans Lenting wrote:
The macro in this thread (I've tested the macro with Word:mac 16.14.1) converts [a plaintext URL] to a hyperlink...


I thought Dziw wanted the opposite -- convert a hyperlink into text.


You’re right.
 


To report site rules violations or get help, contact a site moderator:

ผู้ไกล่เกลี่ยของฟอรัมนี้
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

RegEx or macro to modify hyperlinks






Pastey
Your smart companion app

Pastey is an innovative desktop application that bridges the gap between human expertise and artificial intelligence. With intuitive keyboard shortcuts, Pastey transforms your source text into AI-powered draft translations.

Find out more »
Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »