Replacing variable length file paths in a GEDCOM file
-
Given that the “Dot Matches Newline” info is part of the question template, and ++@Web-Master obviously made use of that template, I am just happy to see evidence that some users are actually able to follow directions. ;-) I’d much rather have users give us that info when it’s not needed then vice versa.
@Web-Master, so that you know: this puts you in good stead relative to many question-askers here. So kudos. :-)
-
@alan-kilborn The file could contain thousands of lines that all start "FILE 1 ", does that change things? They will be randomly scattered (well not actually random, but for these purposes they can be considered to be so)
-
@peterjones As webmaster for a society where our dempgraphic is 55 - 95, having to deal with questions like “Why doesn’t it work?” and “What do you mean by right-click?”, I frequently have to tell people to ‘follow the friggin’ instructions’ (expletives deleted.)
I’m a complete numpty about regex though, so I’m sure I will tax your paitence in other ways!
-
@web-master said in Replacing variable length file paths in a GEDCOM file:
The file could contain thousands of lines that all start "FILE 1 ", does that change things?
Nope, that’s what was anticipated from your problem description.
I’m sure with your attitude you could become adept at regex; there are resources on the FAQ page that you should check out.
-
@alan-kilborn said in Replacing variable length file paths in a GEDCOM file:
@web-master said in Replacing variable length file paths in a GEDCOM file:
Something like this:
Find:
(?-s)^(1 FILE ).+/
Replace:${1}/Smith_1234/
Search mode: Regular expressionbut some of the files have 1million lines!!!
With that much data, before any important transformation operation, please back up your data!
Wow! Got it in one! It worked.
Mind you, the file I chose at random to test it on has a variation on the theme because instead of each line starting "1 FILE " they started "2 FILE ". But tweaking the expression fixed that. What would the syntax be for any line starting 0 - 9 then FILE, please?
-
@web-master said in Replacing variable length file paths in a GEDCOM file:
What would the syntax be for any line starting 0 - 9 then FILE, please?
\dmeans match a single digit (0-9);\d+means match one or more digits (0-99999…) -
@peterjones said in Replacing variable length file paths in a GEDCOM file:
@web-master said in Replacing variable length file paths in a GEDCOM file:
What would the syntax be for any line starting 0 - 9 then FILE, please?
\dmeans match a single digit (0-9);\d+means match one or more digits (0-99999…)OK so if the Find what becomes…
(?-s)^\d( FILE ).+/
… the replace with gets SNAFU’d and loses the inital number
FILE /Smith_1234/Robert Frederic & Audrey Lilian - 3.jpg
instead of
2 FILE /Smith_1234/Robert Frederic & Audrey Lilian - 3.jpg
How do I pass the initial number from the find to the replace please?
-
Why did you take it out of the parentheses? You had
(?-s)^(1 FILE ).+/, and I suggested that you use\dinstead of1, which would have been(?-s)^(\d FILE ).+/… if the\dis in the parentheses, it will be included in the replacement using the$1that’s already there. -
@peterjones I figured that 1 FILE inside the paranetheses was a literal.
-
I figured that 1 FILE inside the paranetheses was a literal.
The parentheses doesn’t make it literal. The parentheses makes it a group, so that it will capture the matched text inside the parentheses as a group, which you can then reference during the replacement to get back pieces of what was in your match. By taking the
\doutside the parentheses, the digit wasn’t kept as part of the group, and thus wasn’t available to be inserted into the replacement.- capture groups (see Numbered Capture Group in that section)
- replacement expressions (see $ℕ in that section)
-
@peterjones Got it! Thank you
This works beautifully. Is there a way to put this into a macro so that at runtime the user is prompted for the replacement string? That would be the cherry on top of the icing/frosting on top of the cake.
No biggie if it’s too big an ask. I’m sure I can coach the user to do it properly
Paul
-
The macro language used by Notepad++ has no concept of “prompt”, so the simple answer is “no”.
“Or something”, OTOH: there is a PythonScript plugin, which allows you to write a script that is run inside of Notepad++ which can automate the Notepad++ GUI and editor contents, which could run that search/replace; but you’d have to install the plugin, and learn how to write such a script. It really depends on how much effort you want to go to now, to make it easier for your users to do this in the future. I think Alan’s posted at least one script in the past that pops up a user input box and asks for text, which then gets populated into a regex that is automatically run on the current file… searching the forum for posts by @Alan-Kilborn that contain
promptmight get you there eventually (though you’ll probably have to wade through quite a few false hits as well…promptisn’t that uncommon a word). -
@peterjones Thanks. I’ll try coaching the user first. :)
I am so impresssed with the speed and quality of response to my post. Thank you so much Alan and Peter
-
@web-master Hi. Here’s a variation on Alan’s solution which has the feature that users enter the replacement text as is (so they won’t have to be so careful about entering text into a field containing cryptic regex codes) :
(?<=^\d FILE /).*(?=/)(Edit: slightly simplified)
-
@neil-schipper said in Replacing variable length file paths in a GEDCOM file:
(?<=^\d FILE /).*(?=/)
Forgive me Neil, but I’m not clear how to use this modified example?
-
@web-master I could have been more clear.
The idea is that you perform a Regex search in the same way as the earlier recipe, except the Find expression is the one I offered, and, the Replace expression is simply and completely the text you want to substitute in.
Thus, instead of your people having to carefully modify the Replace expression from
${1}/Smith_1234/to${1}/Jones_4567/as they proceed from one task to the next, they can more comfortably changeSmith_1234toJones_4567– no funny confusing text in the Replace text box.Also, if you want the solution to be robust against users inadvertently checking that option box to the right of Reg Exp, prefix the Find expression with (?-s) as per Alan’s earlier expression.
Also, if you want to make it impossible to match a completely empty path (nothing between two slashes:
//), in my Find expression, we’d replace*with+, hence:(?-s)(?<=^\d FILE /).+(?=/) -
@neil-schipper Hi Neil. OK, that’s what I thought you meant, but when I do that, Find and Replace does nothing
-
@neil-schipper said in Replacing variable length file paths in a GEDCOM file:
Also, if you want to make it impossible to match a completely empty path (nothing between two slashes: //), in my Find expression, we’d replace * with +
I’m surprised you changed (my) original usage of
.+to.*in your version, then backed it out with “we’d replace * with +”. :-) -
Just to be clear:
Find:(?-s)(?<=^\d FILE /).+(?=/)
Replace:Smith_1234
Mode=regex; checkbox to the right doesn’t matter anymoreThen, Find Next to observe expected matching, Replace to perform the substitution on the currently selected match, Replace All to perform the substitution on entire file.
I have tested this. Are you sure you aren’t acting on a file that has already had the substitutions done?
-
@alan-kilborn said:
you changed (my) original usage of .+ to .*
That’s not how it actually went. I devised my solution independently from reading the OP (deciding early that it should have a look-behind and a look-ahead). Then I saw you had a solution that was satisfactory, and I saw no reason to pipe in.
Much later I noticed in the follow-up convo that @web-master was trying to reduce complexity for his non-technical volunteers, and realized my solution was favorable to that. And it was after that that I realized our solutions also differed in the modifier, and that the asterisk was maybe a bit too loose (although, dollars to doughnuts, they perform equally).