Converting Windows file names to links
-
Hello, @tho-gru, @peterjones and All,
I would like, first, to give some information about pathnames, space chars in files or folders and characters that need the
%nnsyntax in links
When using a DOS command prompt, you can define a full pathname with, either,
\( anti-slash ) or/( slash ) characters or a mix of them ! Of course, when you use normal slashs, the auto-completion mechanism with theTABkey, of folders or files, will not work.In summary, the lines
C:\my folder\My file.txtandC:/my folder/My file.txtare totally equivalent
Usually, when creating a file from the explorer, you may include any space char inside, but not at the very beginning or at the very end of a file or folder. However, if you’ve opened a DOS command prompt and use the DOS
rencommand, you may use the following command :ren File.txt " Fi le . txt " which will rename the "File.txt" file as " Fi le . txt"As you can see, trailing spaces, after any text, in files or folders, are not allowed but you may insert space char(s) at any other location !
Given the regex, used in notepad++, to detect links, I tried to identify all the characters which need the
%nnsyntax, like%20to replace any space char. After some tries, it happens that only two other chars need to be changed, using%nn. So, the complete list is :SPACE %20 { %7B } %7DNow, given all these preliminary elements, we can build a regex to change any full pathmane into a valid hyperlink ! I assume two hypotheses :
-
Only one full pathname per line
-
Each pathmane begins and ends its current line
So, here is a TEST sheet, which explains what must be matched or not matched :
- The regex must MATCH the following lines : d:\ # FULL pathname WITHOUT quotes "d:\" # FULL pathname with QUOTES d:\x\y\file.docx # FULL pathname with SEVERAL levels of SUBDIRS and a final WORD document "d:\ä\ö\straße.txt " # FULL pathname with folders with ACCUENTUATED characters and a SPACE char before the ENDING quote d:/x/y z/file.txt # FULL pathname with a SUBFOLDER containing a SPACE and / SEPARATORS d:\x\y z\fi le.xlsx # FULL pathname with a SUBFOLDER and the FILENAME containing a SPACE and an EXCEL sheet C:\ # FULL pathname with a DIFFERENT DRIVE letter "D:\_DEF\ XY Z" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and WITHIN its name "D:\_DEF\ XY Z\" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and WITHIN its name and a TRAILING anti-slash "D:/_DEF/ XY Z" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and WITHIN its name and / SEPARATORS "D:/_DEF/ XY Z/" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and WITHIN its name and / SEPARATORS and a TRAINLING slash "D:\_DEF\ XY Z\ AB C . txt" # FULL pathname with a SUBDIR and the FILE name containing LEADING and MIDDLE spaces "D:/_DEF/ XY Z/ AB C . txt" # FULL pathname with a SUBDIR and the FILE name containing LEADING and MIDDLE spaces and / SEPARATORS "D:\_DEF\ XY Z\RST" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and INSIDE its name and a FILE name WITHOUT extension "D:/_DEF/ XY Z/RST" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and INSIDE its name and a FILE name WITHOUT extension D:\@@\792\!#$%&'()+,-.;@[]^_` {}~€à×.txt # FULL pathname with SEVERAL levels of SUBDIRS and a FILE name with ALL symbols between 0X20 and 0x7F plus €à× > 0X7F D:/@@/792/!#$%&'()+,-.;@[]^_` {}~€à×.txt # FULL pathname with SEVERAL levels of SUBDIRS and a FILE name with ALL symbols between 0X20 and 0x7F plus €à× > 0X7F and / SEPARATORS "d:\x\y\z\abc.txt " # FULL pathmane with SEVERAL levels of SUBDIRS and TRAILING SPACES after the file EXTENSION - The regex must NOT match any of the following lines : d:\ # With a TRAILING space, leading to file:///d:\%20 , identical to file:///d:\ x: # NO slash NOR anti-slash, after the COLON -:\ # NO DRIVE letter Ä:\ # FORBIDDEN drive value ä:\ # FORBIDDEN drive value \ # NO DRIVE letter and NO COLON d:\ # SPACE beginning the FULL pathname "d:\dir # TRAILING double quote MISSING "d:/dir with space # TRAILING double quote MISSING p:\dir" # LEADING double quote missing d:x\y\file.txt # SLASH or ANTISLASH MISSING after the COLON this is a test # NO FULL pathname d:\x\y \z\abc.txt # Trailing SPACES at END of the Y SUBdirectory "d:\x\y \z\abc.txt" # Trailing SPACES at END of the Y SUBdirectory
As we suppose that only one FULL pathmane must appear on each line, this leads to the following INPUT text :
d:\ "d:\" d:\x\y\file.docx "d:\ä\ö\straße.txt " d:/x/y z/file.txt d:\x\y z\fi le.xlsx C:\ "D:\_DEF\ XY Z" "D:\_DEF\ XY Z\" "D:/_DEF/ XY Z" "D:/_DEF/ XY Z/" "D:\_DEF\ XY Z\ AB C . txt" "D:/_DEF/ XY Z/ AB C . txt" "D:\_DEF\ XY Z\RST" "D:/_DEF/ XY Z/RST" D:\@@\792\!#$%&'()+,-.;@[]^_` {}~€à×.txt D:/@@/792/!#$%&'()+,-.;@[]^_` {}~€à×.txt "d:\x\y\z\abc.txt " d:\ x: -:\ Ä:\ ä:\ \ d:\ "d:\dir "d:/dir with space p:\dir" d:x\y\file.txt this is a test d:\x\y \z\abc.txt "d:\x\y \z\abc.txt"Beware : the second
d:\is followed with a space char, => NO match
We need two regexes S/R in order to get functional hyperlinks :
-
The first S/R
Awill transform any FULL pathname into an hyperlink, beginning with the syntaxfile:/// -
The second S/R
Bwill replace any character SPACE,{and}with, respectively, the strings%20,%7Band%7D, only on lines beginning with thefile:///syntax
I will use the free-spacing mode
(?x), in the search regexes, to better visualize the different regex parts. So :- The S/R A is :
SEARCH
(?xi) ^ (")? ( [A-Z] : [/\\] (?: (?: (?![/"\\]) \S | \x20 )* (?![/"\\]) \S [/\\] )* (?: (?: (?![/"\\]) \S | \x20 )* (?![/"\\]) \S )? ) (?(1)\x20*") $REPLACE
file:\x2F\x2F\x2F\2- The S/R B is :
SEARCH
(?x-is) ^ (?!file:/{3}) .+ (*SKIP) (*FAIL) | ( \x20 ) | ( { ) | ( } )REPLACE
(?1%20)(?2%7B)(?3%7D)
Then, the road map is :
-
Select the zone containing all your full pathnames list, which will be changed into hyperlinks
-
Open the Replace dialog (
Ctrl + H)-
Hit the
Delkey to clear theFind what:zone -
Check the
In selectionoption -
SEARCH
(?xi) ^ (")? ( [A-Z] : [/\\] (?: (?: (?![/"\\]) \S | \x20 )* (?![/"\\]) \S [/\\] )* (?: (?: (?![/"\\]) \S | \x20 )* (?![/"\\]) \S )? ) (?(1)\x20*") $ -
REPLACE
file:\x2F\x2F\x2F\2 -
Select the
Regular expressionsearch mode -
Click on the
Replace Allbutton
-
=> A message appears :
Replace All: 18 occurrences were replaced in selected text-
-
SEARCH
(?x-is) ^ (?!file:/{3}) .+ (*SKIP) (*FAIL) | ( \x20 ) | ( { ) | ( } ) -
REPLACE
(?1%20)(?2%7B)(?3%7D) -
Click again on the
Replace Allbutton
-
=> A message appears :
Replace All: 69 occurrences were replaced in selected textAnd it gives the expected OUTPUT text :
file:///d:\ file:///d:\ file:///d:\x\y\file.docx file:///d:\ä\ö\straße.txt file:///d:/x/y%20z/file.txt file:///d:\x\y%20z\fi%20le.xlsx file:///C:\ file:///D:\_DEF\%20%20XY%20%20%20Z file:///D:\_DEF\%20%20XY%20%20%20Z\ file:///D:/_DEF/%20%20XY%20%20%20Z file:///D:/_DEF/%20%20XY%20%20%20Z/ file:///D:\_DEF\%20%20XY%20%20%20Z\%20%20AB%20%20%20C%20%20.%20%20%20txt file:///D:/_DEF/%20%20XY%20%20%20Z/%20%20AB%20%20%20C%20%20.%20%20%20txt file:///D:\_DEF\%20%20XY%20%20%20Z\RST file:///D:/_DEF/%20%20XY%20%20%20Z/RST file:///D:\@@\792\!#$%&'()+,-.;@[]^_`%20%7B%7D~€à×.txt file:///D:/@@/792/!#$%&'()+,-.;@[]^_`%20%7B%7D~€à×.txt file:///d:\x\y\z\abc.txt d:\ x: -:\ Ä:\ ä:\ \ d:\ "d:\dir "d:/dir with space p:\dir" d:x\y\file.txt this is a test d:\x\y \z\abc.txt "d:\x\y \z\abc.txt"IMPORTANT : When you double -click on an hyperlink, containing an existing file, it automatically opens in its default application => For instance, any
.docxis lauched with Microsoft Word and any.xlsxstarts with Microsoft Excel !
Notes :
- For the first S/R, we can, as well, split over the search regex, in several lines, like below :
(?xi) ^ (")? # An OPTIONAL leading quote at BEGINNING of line, stored in Group 1 ( # START of Group 2 [A-Z] : [/\\] # DRIVE letter, colon and SLASH or ANTI-SLASH (?: (?: (?![/"\\]) \S | \x20 )* (?![/"\\]) \S [/\\] )* # OPTIONAL SUBSEQUENT subfolder(s) chars, ending with a NON-SPACE char, before a SLASH or ANTI-SLASH (?: (?: (?![/"\\]) \S | \x20 )* (?![/"\\]) \S )? # OPTIONAL NON-SPACE or SPACE chars, ending with a NON-SPACE char ( LAST subfolder or FOLE NAME part ) ) # END of Group 2 (?(1)\x20*") $ # OPTIONAL SPACES and the ENDING quote ( if LEADING quote at START ), before the END of CURRENT line- Regarding the second S/R, we could also have used this other search version, for same results :
(?x-is) (?: ^file:/{3} | (?!\A)\G ) .*? \K (?: ( \x20 ) | ( { ) | ( } ) )Best Regards,
guy038
P.S. : This method works for both
ANSIandUTF-8/UTF-8-BOMencodings ! -
-
That is a good idea. I did not know that is is possible with macros to set values in search an replace dialog. Is there an option to transfer a macro from one to another Notepad++ installation?
-
Re: Converting Windows file names to links
@guy038 thanks for your supposed solution.
These is some details i am thinking about: When recording a macro using the find dialog
- How to activate the regex checkbox when not knowing its state?
- How to restore the regex flag in the dialog at the end of the macro?
The background is, I want to distribute this macro to my colleagues who perhaps do not know anything about the regex flag.
PS: In the thread how-to-share-a-recorded-marco-with-others i found the solution for copying macros between notepad++ installations.
-
@tho-gru said in Converting Windows file names to links:
Is there an option to transfer a macro from one to another Notepad++ installation?
Yes, in
shortcuts.xmlmacros appear between <Macro> and </Macro> tags. You may copy textually from one file (on one PC) into another copy of the file (from a different PC) if you heed the advice HERE in the user manual. Also note that you can just take the ENTIRE file if you want that level of identicality. -
@tho-gru said in Converting Windows file names to links:
When recording a macro using the find dialog
How to activate the regex checkbox when not knowing its state?
How to restore the regex flag in the dialog at the end of the macro?Don’t worry about these things. Record your macro using the UI settings you need. When your macro is run by the user, it uses the settings without changing anything in the user interface.
Don’t think of it like if you record a bunch of replacement actions into a macro and then play the macro while watching the Replace window, thinking you’ll see things change really fast in the window, and be left with the setup from the final replace in the macro – doesn’t work that way.
-
Hi @guy038,
I use notepad++:
##################################
Notepad++ v8.4.4 (64-bit)
Build time : Jul 15 2022 - 17:54:42
Path : C:\Program Files\Notepad++\notepad++.exe
Command Line : -multiInst
Admin mode : OFF
Local Conf mode : OFF
Cloud Config : OFF
OS Name : Windows 10 Pro (64-bit)
OS Version : 21H2
OS Build : 19044.1889
Current ANSI codepage : 1252
Plugins :
ComparePlugin (2.0.2)
DSpellCheck (1.4.24)
JSMinNPP (1.2205)
mimeTools (2.8)
NppConverter (4.4)
NppExec (0.8)
NppExport (0.4)
PythonScript (2)
XMLTools (3.1.1.13)
##################################I copied S/R A into the replace dialog:
(?xi) ^ (")? ( [A-Z] : [/\] (?: (?: (?![/"\]) \S | \x20 )* (?![/"\]) \S [/\] )* (?: (?: (?![/"\]) \S | \x20 )* (?![/"\]) \S )? ) (?(1)\x20*") $When I click on replace all nothing hapens.
When I click on find I got the message that the regex is syntactically wrong:
Can you please tell me, what i did wrong?
Kind Regards
Thomas -
@tho-gru said in Converting Windows file names to links:
When I click on find I got the message that the regex is syntactically wrong.
Can you please tell me, what i did wrong?Well, this is dangerously close to expecting other people to do your work for you. I mean, if you get into that situation, you should remove stuff from your expression slowly, experimenting, and at some point you’ll see what you did wrong. Then you can slowly add back in, testing, and get your expression correct.
But… If I copy your expression and press Find Next, I get no message about it being “syntactically wrong”. I get “Can’t find the text…” which means the syntax is correct.
-
Hi, @tho-gru, @peterjones, @alan-kilborn and All,
First of all, I want to apologize about an obvious error, in the Regex
AReplacement part :I said :
REPLACE file///\2Of course, the correct regex is
REPLACE
file:///\2Secondly, to avoid that this regex, itself, to be an hyperlink, I prefered this final syntax :
REPLACE
file:\x2F\x2F\x2F\2Important : I updated my previous post, accordingly, in order the info to be accurate !
Now regarding your problem, I first noticed that your regex is not the same as mime, as its just considers the case of pathnames with slashs only, like in
D:/ABC/xYZ.txtBut, even with this restriction, if I run your regex against the INPUT text, provided in my previous post, I did get
6replacements, relative to all the pathnames with usual/of the test list !So, I don’t know why you found a malformed regex expression ?
Notepad++ v8.4.4 (64-bit)
Build time : Jul 15 2022 - 17:54:42
Path : E:\844_x64\notepad++.exe
Command Line :
Admin mode : OFF
Local Conf mode : ON
Cloud Config : OFF
OS Name : Windows 10 Pro (64-bit)
OS Version : 21H2
OS Build : 19044.1949
Current ANSI codepage : 1252
Plugins :
mimeTools (2.8)
NppConverter (4.4)
NppExport (0.4)
ComparePlus (1)
If you use the complete regex S/R
A, given ( and updated ) in my previous post, you should get18replacements, as before !Best Regards
guy038
-
Hi @guy038 and @Alan-Kilborn and everyone,
I finally find the (or my) error…
When I use the regex A from guy is does not work. After watching some additional time on the regex I simply guess that the character combinations \] must be converted to \\] (when writing this text the preview function shows that \-chars must be entered twice to appear in the preview).
This following regex works for me:
(?xi) ^ (")? ( [A-Z] : [/\\\\] (?: (?: (?![/"\\\\]) \S | \x20 )* (?![/"\\\\]) \S [/\\\\] )* (?: (?: (?![/"\\\\]) \S | \x20 )* (?![/"\\\\]) \S )? ) (?(1)\x20*") $So perhaps the solution provided by guy is now more useful for other people.
-
Hi @guy038 and @Alan-Kilborn and everyone,
I finally find the (or my) error…
When I use the regex A from guy is does not work. After watching some additional time on the regex I simply guess that the character combinations backslash followed by closing square bracket must be converted to backslash, backslash followed by closing square bracket.
Even the live preview looks different than the final post.
Unfortunately while trying to provide some text representation of the new regex failed. Here is a screen shot:
So perhaps the solution provided by guy is now more useful for other people.
PS: This forum software is quite ugly to use. It often complain about spam suspicious posts and only left 5 minutes to edit. Therefore the repost.
-
This thread is hopelessly muddled.
I hope a moderator comes along and straightens it out.the character combinations backslash followed by closing square bracket must be converted to backslash, backslash followed by closing square bracket
Yes, there is a website bug with the backslash-closingSquareBracket sequence. It is better to use the following for the closingSquareBracket to avoid the bug:
0x5D.Guy knows about this bug and I would have thought his earlier postings would not have included such problems.
-
avoid the bug:
0x5DI think you mean
\x5D;-)I hope a moderator comes along and straightens it out.
@guy038 has the moderator power necessary to go back and edit his own posts, to have the regex use a reasonable escape of
\x5Dinstead of trying to get the backslash-closebracket to go through this forum correctly. I am not about to try to edit a guy-regex for republishing, because I’d never know if I broke it while trying to edit it. ;-) -
@tho-gru said:
This forum software is quite ugly to use. It often complain about spam suspicious posts and only left 5 minutes to edit.
It may complain about certain things until you have a reputation >= 2.
The 5 minute limit affects everyone. It’s not so bad. It encourages you to proofread what you write before posting. If you see an error later (passed the time limit), simply post again and say the error and the correction.
-
@tho-gru said in Converting Windows file names to links:
It often complain about spam suspicious posts
I think you mean “It rarely complains about spam suspicious posts”. In my ~6000 posts here, I have seen it only a handful of times (around 1 time per thousand). That doesn’t seem a bad tradeoff for the number of times the Akismet filter has caught posts which contains huge amounts of spam, or someone trying to post the contents of a binary file (presumably trying to upload a virus or similar). It’s a tradeoff that the Administrators are willing to make.
The 5 minute limit affects everyone
And some of us more often than others. ;-) (I am notorious for finding typos after I post.)
I recently checked the forum settings: unfortunately, there is no way to enable the feature I’d really want: “you are allowed to edit your post until someone has replied”. The 5 minute timeout is the most reasonable compromise we can make between giving people long enough to fix typos and making sure that people don’t change history (otherwise, a nefarious user could say something innocuous, encouraging other users to chime in with “I agree”, and then go back and change the statement to something completely different, which makes the whole conversation a lie)
And despite saying, a few minutes ago, that @guy038 could go back and edit his older posts to fix the regex, at this point, it would make much more sense in the context of the discussion, for Guy to make a new reply post, with the regex fixed to use
\x5Dinstead of trying to get the forum to handle backslash-closeSquareBracket correctly. -
Hello, @tho-gru, @peterjones, @alan-kilborn and All,
Oh, my god ! I’m terribly sorry because I haven’t noticed that the
\character was not properly displayed in regexA:-((@tho-gru, you said :
I finally find the (or my) error…
It’s definitively not your error, It’s mine :-(
Most of the time, due to our forum and/or Markdown syntax some characters need to be changed into their escape syntax when expressed in regexes.
So :
-
When you search for a literal
[char, use preferably the\x5Bsyntax -
When you search for a literal
\char, use preferably the\x5Csyntax -
When you search for a literal
]char, use preferably the\x5Dsyntax -
When you search for a literal
backtickchar, use preferably the\x60syntax
Of course, in the regex
A, the parts[/\x5C]and[/"\x5C]are real class characters, so the[and]are not literal chars but a specific regex syntax !Again, sorry for my mistake which must have made you look for a long time !
So, here is the correct version of my old post :
Hello, @tho-gru, @peterjones, @alan-kilborn and All,
I would like, first, to give some information about pathnames, space chars in files or folders and characters that need the
%nnsyntax in links
When using a DOS command prompt, you can define a full pathname with, either,
\( anti-slash ) or/( slash ) characters or a mix of them ! Of course, when you use normal slashs, the auto-completion mechanism with theTABkey, of folders or files, will not work.In summary, the lines
C:\my folder\My file.txtandC:/my folder/My file.txtare totally equivalent
Usually, when creating a file from the explorer, you may include any space char inside, but not at the very beginning or at the very end of a file or folder. However, if you’ve opened a DOS command prompt and use the DOS
rencommand, you may use the following command :ren File.txt " Fi le . txt " which will rename the "File.txt" file as " Fi le . txt"As you can see, trailing spaces, after any text, in files or folders, are not allowed but you may insert space char(s) at any other location !
Given the regex, used in notepad++, to detect links, I tried to identify all the characters which need the
%nnsyntax, like%20to replace any space char. After some tries, it happens that only two other chars need to be changed, using%nn. So, the complete list is :SPACE %20 { %7B } %7DNow, given all these preliminary elements, we can build a regex to change any full pathmane into a valid hyperlink ! I assume two hypotheses :
-
Only one full pathname per line
-
Each pathmane begins and ends its current line
So, here is a TEST sheet, which explains what must be matched or not matched :
- The regex must MATCH the following lines : d:\ # FULL pathname WITHOUT quotes "d:\" # FULL pathname with QUOTES d:\x\y\file.docx # FULL pathname with SEVERAL levels of SUBDIRS and a final WORD document "d:\ä\ö\straße.txt " # FULL pathname with folders with ACCUENTUATED characters and a SPACE char before the ENDING quote d:/x/y z/file.txt # FULL pathname with a SUBFOLDER containing a SPACE and / SEPARATORS d:\x\y z\fi le.xlsx # FULL pathname with a SUBFOLDER and the FILENAME containing a SPACE and an EXCEL sheet C:\ # FULL pathname with a DIFFERENT DRIVE letter "D:\_DEF\ XY Z" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and WITHIN its name "D:\_DEF\ XY Z\" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and WITHIN its name and a TRAILING anti-slash "D:/_DEF/ XY Z" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and WITHIN its name and / SEPARATORS "D:/_DEF/ XY Z/" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and WITHIN its name and / SEPARATORS and a TRAINLING slash "D:\_DEF\ XY Z\ AB C . txt" # FULL pathname with a SUBDIR and the FILE name containing LEADING and MIDDLE spaces "D:/_DEF/ XY Z/ AB C . txt" # FULL pathname with a SUBDIR and the FILE name containing LEADING and MIDDLE spaces and / SEPARATORS "D:\_DEF\ XY Z\RST" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and INSIDE its name and a FILE name WITHOUT extension "D:/_DEF/ XY Z/RST" # FULL pathname with a SUBDIR containing SPACES at BEGINNING and INSIDE its name and a FILE name WITHOUT extension D:\@@\792\!#$%&'()+,-.;@[]^_` {}~€à×.txt # FULL pathname with SEVERAL levels of SUBDIRS and a FILE name with ALL symbols between 0X20 and 0x7F plus €à× > 0X7F D:/@@/792/!#$%&'()+,-.;@[]^_` {}~€à×.txt # FULL pathname with SEVERAL levels of SUBDIRS and a FILE name with ALL symbols between 0X20 and 0x7F plus €à× > 0X7F and / SEPARATORS "d:\x\y\z\abc.txt " # FULL pathmane with SEVERAL levels of SUBDIRS and TRAILING SPACES after the file EXTENSION - The regex must NOT match any of the following lines : d:\ # With a TRAILING space, leading to file:///d:\%20 , identical to file:///d:\ x: # NO slash NOR anti-slash, after the COLON -:\ # NO DRIVE letter Ä:\ # FORBIDDEN drive value ä:\ # FORBIDDEN drive value \ # NO DRIVE letter and NO COLON d:\ # SPACE beginning the FULL pathname "d:\dir # TRAILING double quote MISSING "d:/dir with space # TRAILING double quote MISSING p:\dir" # LEADING double quote missing d:x\y\file.txt # SLASH or ANTISLASH MISSING after the COLON this is a test # NO FULL pathname d:\x\y \z\abc.txt # Trailing SPACES at END of the Y SUBdirectory "d:\x\y \z\abc.txt" # Trailing SPACES at END of the Y SUBdirectory
As we suppose that only one FULL pathmane must appear on each line, this leads to the following INPUT text :
d:\ "d:\" d:\x\y\file.docx "d:\ä\ö\straße.txt " d:/x/y z/file.txt d:\x\y z\fi le.xlsx C:\ "D:\_DEF\ XY Z" "D:\_DEF\ XY Z\" "D:/_DEF/ XY Z" "D:/_DEF/ XY Z/" "D:\_DEF\ XY Z\ AB C . txt" "D:/_DEF/ XY Z/ AB C . txt" "D:\_DEF\ XY Z\RST" "D:/_DEF/ XY Z/RST" D:\@@\792\!#$%&'()+,-.;@[]^_` {}~€à×.txt D:/@@/792/!#$%&'()+,-.;@[]^_` {}~€à×.txt "d:\x\y\z\abc.txt " d:\ x: -:\ Ä:\ ä:\ \ d:\ "d:\dir "d:/dir with space p:\dir" d:x\y\file.txt this is a test d:\x\y \z\abc.txt "d:\x\y \z\abc.txt"Beware : the second
d:\is followed with a space char, => NO match
We need two regexes S/R in order to get functional hyperlinks :
-
The first S/R
Awill transform any FULL pathname into an hyperlink, beginning with the syntaxfile:/// -
The second S/R
Bwill replace any character SPACE,{and}with, respectively, the strings%20,%7Band%7D, only on lines beginning with thefile:///syntax
I will use the free-spacing mode
(?x), in the search regexes, to better visualize the different regex parts. So :- The S/R A is :
SEARCH
(?xi) ^ (")? ( [A-Z] : [/\x5C] (?: (?: (?![/"\x5C]) \S | \x20 )* (?![/"\x5C]) \S [/\x5C] )* (?: (?: (?![/"\x5C]) \S | \x20 )* (?![/"\x5C]) \S )? ) (?(1)\x20*") $REPLACE
file:\x2F\x2F\x2F\2- The S/R B is :
SEARCH
(?x-is) ^ (?!file:/{3}) .+ (*SKIP) (*FAIL) | ( \x20 ) | ( { ) | ( } )REPLACE
(?1%20)(?2%7B)(?3%7D)
Then, the road map is :
-
Select the zone containing all your full pathnames list, which will be changed into hyperlinks
-
Open the Replace dialog (
Ctrl + H)-
Hit the
Delkey to clear theFind what:zone -
Check the
In selectionoption -
SEARCH
(?xi) ^ (")? ( [A-Z] : [/\x5C] (?: (?: (?![/"\x5C]) \S | \x20 )* (?![/"\x5C]) \S [/\x5C] )* (?: (?: (?![/"\x5C]) \S | \x20 )* (?![/"\x5C]) \S )? ) (?(1)\x20*") $ -
REPLACE
file:\x2F\x2F\x2F\2 -
Select the
Regular expressionsearch mode -
Click on the
Replace Allbutton
-
=> A message appears :
Replace All: 18 occurrences were replaced in selected text-
-
SEARCH
(?x-is) ^ (?!file:/{3}) .+ (*SKIP) (*FAIL) | ( \x20 ) | ( { ) | ( } ) -
REPLACE
(?1%20)(?2%7B)(?3%7D) -
Click again on the
Replace Allbutton
-
=> A message appears :
Replace All: 69 occurrences were replaced in selected textAnd it gives the expected OUTPUT text :
file:///d:\ file:///d:\ file:///d:\x\y\file.docx file:///d:\ä\ö\straße.txt file:///d:/x/y%20z/file.txt file:///d:\x\y%20z\fi%20le.xlsx file:///C:\ file:///D:\_DEF\%20%20XY%20%20%20Z file:///D:\_DEF\%20%20XY%20%20%20Z\ file:///D:/_DEF/%20%20XY%20%20%20Z file:///D:/_DEF/%20%20XY%20%20%20Z/ file:///D:\_DEF\%20%20XY%20%20%20Z\%20%20AB%20%20%20C%20%20.%20%20%20txt file:///D:/_DEF/%20%20XY%20%20%20Z/%20%20AB%20%20%20C%20%20.%20%20%20txt file:///D:\_DEF\%20%20XY%20%20%20Z\RST file:///D:/_DEF/%20%20XY%20%20%20Z/RST file:///D:\@@\792\!#$%&'()+,-.;@[]^_`%20%7B%7D~€à×.txt file:///D:/@@/792/!#$%&'()+,-.;@[]^_`%20%7B%7D~€à×.txt file:///d:\x\y\z\abc.txt d:\ x: -:\ Ä:\ ä:\ \ d:\ "d:\dir "d:/dir with space p:\dir" d:x\y\file.txt this is a test d:\x\y \z\abc.txt "d:\x\y \z\abc.txt"IMPORTANT : When you double -click on an hyperlink, containing an existing file, it automatically opens in its default application => For instance, any
.docxis lauched with Microsoft Word and any.xlsxstarts with Microsoft Excel !
Notes :
- For the first S/R
A, we can, as well, split over the search regex, in several lines, like below :
(?xi) ^ (")? # An OPTIONAL leading quote at BEGINNING of line, stored in Group 1 ( # START of Group 2 [A-Z] : [/\x5C] # DRIVE letter, colon and SLASH or ANTI-SLASH (?: (?: (?![/"\x5C]) \S | \x20 )* (?![/"\x5C]) \S [/\x5C] )* # OPTIONAL SUBSEQUENT subfolder(s) chars, ending with a NON-SPACE char, before a SLASH or ANTI-SLASH (?: (?: (?![/"\x5C]) \S | \x20 )* (?![/"\x5C]) \S )? # OPTIONAL NON-SPACE or SPACE chars, ending with a NON-SPACE char ( LAST subfolder or FOLE NAME part ) ) # END of Group 2 (?(1)\x20*") $ # OPTIONAL SPACES and the ENDING quote ( if LEADING quote at START ), before the END of CURRENT line- Regarding the second S/R
B, we could also have used this other search version, for same results :
(?x-is) (?: ^file:/{3} | (?!\A)\G ) .*? \K (?: ( \x20 ) | ( { ) | ( } ) )Best Regards,
guy038
P.S. : This method works for both
ANSIandUTF-8/UTF-8-BOMencodings ! -
-
This post is deleted! -
Thanks for all your help. I appreciate it.
When using this macro in my environment it work really fine.
I figured out an additional requirement while using it: The macro must leave already converted links untouched. This requirement is already fulfilled in my opinion because either S/R
Aand S/RBwill not match any more.This is really useful!
Regards
Thomas
