regular expression

In my personal documents I'm using a sort of Naming Convention where all my files are named as follows yyyy-mm-dd-FileName.xyz The first characters refer to the Last Modified Date that in many cases represent the Creation Date of the file. ".xyz" I don't change it because it is the file...

Can anyone help with the following.... I am tryiing to write a Regular Expression Patterm to find all instances within a string. The data is a date/time followed by a name followed by (Work notes) or (Shared notes) and then the actual notes. e.g. the string would look like this.... 26/07/2019...

Is this some kind of undocumented bug, or am I having brain gas?? Here is the string... myStr = "<comment id='234679' author='Bill McKale' created='Wed, 14 Jun 2019 11:56:44 -4000'>'This is not a viable solution. Please read SOP 48824.66A'<comment>" Here are 4 variations of the pattern...

Hi, I've a string like "abc.txt def.txt lmn.png jkl.jpeg pvr.txt". THis pattern "\w*(?=\.txt)" only extract file names of text files i.e abc,def,pvr. Now I want the opposite of this. I want to extract file names that are not text i.e lmn and jkl Please suggest the pattern to match this. If...

Hello, I've got an excel sheet with ~120K rows of text. The text contains automotive data, and it is NOT consistent in location/placement/formatting, except the year ranges it seems. Sample data: '02-06 Acura RSX Base/ 02-06 Honda Civic Si 4-2-1 Polished S.S. Header One Piece' '96-97 Acura...

Hi there. I've got a weekly work task involving the extraction of filenames from 10,000+ unwieldy and inconsistently-formatted network filepaths. Adding complication is the fact that these are multivalue: the same cells contain multiple filepaths\filenames separated by semicolons. I need to...

Hi Guys, Long time user but first time poster. I have always been able to find solutions and model them to my usage from this gem of a website. Kudos to the content here. I have a deadline on Monday and need to somehow gather a lot of info from a thousands of rows of product...

I have a notepad containing tags. My requirement is to change the data as below: My input file will have 1000+ lines with the similar data to be replaced. Actual: <a xlink:href="javascript:alert('XGMC021D');" xlink:title="XGMC021D"> <ellipse fill="none" stroke="black" cx="1548" cy="-898"...

Can somebody give me a regular expression to do an approximate, atleast 3 letter match between two words. For example I have "Alex Mike" in one column and "mAlex" in another. There is a space in between Alex and Mike and we are comparing to mAlex. I think its tricky. I tried using the...

Hi People I have searched a _lot_ for this solution, but I do not know how to do it in VBA. I want to be able to call a function in the following way: MsgBox RegExp("abc123def456", "a(.+?)def(.+?)6", "$1Hello$2") And for that to return: bc123Hello45 I have found many regex functions, but...