Click here to Skip to main content
15,907,183 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
QuestionRegEx- Find files in Linux which match the expression Pin
JDMils3-Jan-23 16:16
JDMils3-Jan-23 16:16 
AnswerRe: RegEx- Find files in Linux which match the expression Pin
Richard MacCutchan3-Jan-23 21:32
mveRichard MacCutchan3-Jan-23 21:32 
AnswerRe: RegEx- Find files in Linux which match the expression Pin
k50544-Jan-23 9:12
mvek50544-Jan-23 9:12 
GeneralRe: RegEx- Find files in Linux which match the expression Pin
JDMils8-Jan-23 12:56
JDMils8-Jan-23 12:56 
QuestionRegular Expression to find parts of a <script/img src=""> or <link href=""> attribute value Pin
Steve M Penner3-Jan-23 5:13
Steve M Penner3-Jan-23 5:13 
QuestionParsing Session Campaign Data in Data Studio Pin
Michael Oct20223-Jan-23 3:16
Michael Oct20223-Jan-23 3:16 
AnswerRe: Parsing Session Campaign Data in Data Studio Pin
Michael Oct20223-Jan-23 5:01
Michael Oct20223-Jan-23 5:01 
QuestionNeed a bit of help concerning RegEx Pin
Regis Maltais 202112-Dec-22 23:42
Regis Maltais 202112-Dec-22 23:42 
I own few virtual pinball files that I need to be clean up.
I was planning to use RegEx in Excel to clean them out, I'm ok with VBA programming
I know what RegxEx is and what it can do but I'm not familiar on how to write them

Can you help me with those ?

Here is an example of the files and the suggested RegEx "\(.*\).*(?=\[0-9a-zA-Z\.]+\.vpx)":

F:\vPinball\VisualPinball\Tables\Cross Town (Gottlieb 1966).vpx
F:\vPinball\VisualPinball\Tables\Wild Fyre (Stern 1978) 1.1.vpx
F:\vPinball\VisualPinball\Tables\Pirates of the Caribbean Siggis Mod 1.0.vpx
F:\vPinball\VisualPinball\Tables\Punk wip 12.vpx
F:\vPinball\VisualPinball\Tables\Attack from Mars (Bally1995) g5k 1.1.vpx
F:\vPinball\VisualPinball\Tables\Flying Chariots (Gottlieb 1963).vpx
F:\vPinball\VisualPinball\Tables\Lady Luck (Bally 1986) 1.1.vpx
F:\vPinball\VisualPinball\Tables\Fathom (Bally 1981) 1.1a.vpx
F:\vPinball\VisualPinball\Tables\Conan (Rowamet 1983) v1.1a.vpx
F:\vPinball\VisualPinball\Tables\Black Knight - Sword Of Rage.vpx
F:\vPinball\VisualPinball\Tables\Heat Wave (Williams 1964).vpx
F:\vPinball\VisualPinball\Tables\Full (Recreativos Franco 1977).vpx

Ideally the expected name will be Back To The Future.vpx by example

Someone did suggested me this RegEx mentionned earlier, which did most of the cleaning but after running the VBA there a still few that weren't cleaned

Here are those:

Back To The Future 1.4 PF Mod.png
Back To The Future 1.4 PF Mod_thumb.png
Back To The Future 1.4 PF Mod_thumb_sm.png
Back to the Future 1.05 .png
Back to the Future 1.06 .png
Back to the Future 1.14.png
Back to the Future 1.15.png
back to the future 2 mf.png
back to the future mf.png
Back To The Future Starlion MoD.png
Back To The Future Starlion MoD_thumb.png
Back To The Future Starlion MoD_thumb_sm.png

Ideally I was looking for Back To The Future.png

Can you help me please ?

Thanks
AnswerRe: Need a bit of help concerning RegEx Pin
OriginalGriff12-Dec-22 23:47
mveOriginalGriff12-Dec-22 23:47 
QuestionWhy does this work but this doesn't Pin
Andrew St. Hilaire26-Nov-22 16:52
Andrew St. Hilaire26-Nov-22 16:52 
QuestionRe: Why does this work but this doesn't Pin
k505426-Nov-22 17:30
mvek505426-Nov-22 17:30 
AnswerRe: Why does this work but this doesn't Pin
Andrew St. Hilaire26-Nov-22 17:51
Andrew St. Hilaire26-Nov-22 17:51 
AnswerRe: Why does this work but this doesn't Pin
Richard Deeming27-Nov-22 22:11
mveRichard Deeming27-Nov-22 22:11 
AnswerRe: Why does this work but this doesn't Pin
jschell28-Nov-22 10:42
jschell28-Nov-22 10:42 
QuestionHow to remove an & in the following expressions Pin
Victor Nijegorodov21-Nov-22 8:31
Victor Nijegorodov21-Nov-22 8:31 
AnswerRe: How to remove an & in the following expressions Pin
k505421-Nov-22 10:21
mvek505421-Nov-22 10:21 
GeneralRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 3:32
Victor Nijegorodov22-Nov-22 3:32 
AnswerRe: How to remove an & in the following expressions Pin
Richard MacCutchan21-Nov-22 21:50
mveRichard MacCutchan21-Nov-22 21:50 
GeneralRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 2:41
Victor Nijegorodov22-Nov-22 2:41 
GeneralRe: How to remove an & in the following expressions Pin
Richard MacCutchan22-Nov-22 3:13
mveRichard MacCutchan22-Nov-22 3:13 
GeneralRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 3:59
Victor Nijegorodov22-Nov-22 3:59 
AnswerRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 4:05
Victor Nijegorodov22-Nov-22 4:05 
QuestionRegex search to find and remove consecutive lines which end with same characters Pin
Member 1582987913-Nov-22 5:05
Member 1582987913-Nov-22 5:05 
AnswerRe: Regex search to find and remove consecutive lines which end with same characters Pin
jschell14-Nov-22 6:43
jschell14-Nov-22 6:43 
QuestionRemoving + - chars if lines are starting with them only Pin
montaigne gremo2-Nov-22 2:32
montaigne gremo2-Nov-22 2:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.