regex

Hi , Want Regex in excel formulae as mention below input and output for reference. Input Output 3005AB1394714000000 AB139471 2022ABR52447FPV ABR52447 2022A9561554PPV A9561554 2022ABR52240LTW ABR52240 2022PAR45939FPV PAR45939 2022PNN03733FPV PNN03733 2019Z6167512 Z6167512...

Hello! I searched for a while how to fix my problem but none of the solutions works fine, so I come here hoping some new help :) This is an example of string I got in my table : 417720;2;2003;431967;432071;432135;432071;432504;432135;432504;433695 I would like to extract all number of 6...

Hello everybody! I'm a beginner in PowerQuery and I try to extract all numbers of 6 digits in a string for each of my records. For example, following string I have : 497887;443445;#789788,112456,test;999877;john 788487 From this one, I'd like to extract the following value ...

I have a workbook 'tool' which needs to validate the names given to the files being output. The validation requires that, where the filename starts with 'ABC_', it should be one of a set of known syntaxes, i.e. ABC_2020_[MF]_(#_##%_S#_#_A#_##%_W#%) i.e. ABC_2020_M_(1_50%_S7_5_A0_25%_W1%)...

I want to write a regular expression in vba that accepts 1,2 or 3 (-) or 1,2 or 3 (+) and series of digits(0-9), and it can repeat so for example +++5+2-10+6 is accepted ++++5 is not accepted because there 4 (+) as well as ----10+2 not accepted because there are 4 (-) I have tried many regex...

Hello guys, i have html with images different sizes and i want to select only one with 960 resolution in link, i tried with some formula and it's not working the best in some cases it doesn't extract right, ill share with you spreadsheet with example I have one more question, i have this code...

Hello, I'm looking for help in locating and replacing/deleting the following pattern within a string in a cell: "xxx.xxxxx.xxx.xxxxx.xxxxxxxxxxx" where x represents a numerical character i just learned how to use regExp...but can't figure out for the life of me how to tell it to look for the...

coming from this thread String Parsing I was able to convert @Peter_SSs function code to an ordinary procedure. (thanks again @Peter_SSs ) Sub PetListII() Dim RX As Object, M As Object, RXCtr As Integer Dim K As Integer, ConfisKated As String, FullName As Variant, MaxNumero() As...

Trying to use run the Regex trick (that members Grah and Bo_Ry skillfully adapted for this case), I run into a problem which might have to with my worksheet not being a table. The error text is: Expression.Error: The field 'Comment' of the record wasn't found. Details: Name=Sheet1 Data=...

Hi, I want to make a macro to search for repeating blocks of text in a text file. I know how to load the text file to memory but I don't know how to find the repeated text. I've seen examples of searching for text using regular expressions which seems like it might be the way to go, but I...

Dim MyRegExp As RegExp Set MyRegExp = New RegExp With MyRegExp .Pattern = "(?<=Your message wasn't delivered to )(.*)(?= because)"...

Dim MyRegExp As RegExp Set MyRegExp = New RegExp With MyRegExp .Pattern = "(?<=Your message wasn't delivered to )(.*)(?= because)"...

I have been stuck googling for a while now. What I am trying to do is: 1. First check if "mystring" is in column S (s_col) 2. If so, search column P (p_col) for a year that has white space in front and at the end 3. Paste that year into column k (k_col) However I keep getting an error that...

Hi, I'm working on a program that I want to recognize if a cell contains any number in it by leveraging a RegEx. Currently it isn't working and only returns text when the cell has numbers and text. In the cell I have "55112 5 mile radius" & the cell format is listed as general. Would love any...

Hi, So I have a list if alphanumeric IDs that I'd like to modify using RegEx to create an in-cell function. I've already enabled Microsoft VBScript Regular Expression 5.5, and I'm using the below code: Function simpleCellRegex(Myrange As Range) As String Set regEx =...

I've been assign a task where I need to map data from a PDF converted excel file to another exported excel file with pre-determined headers. The goal is to standardized the converted PDF so that the data can be extracted to the exported excel file in vba. One big issue I foresee is that the...

Hello everybody. I've a cell assuming different values. For example: 105,32 euro Now, with regex I've removed the non numeric value in order to have 105,32 My code: Dim replacement As Object, trunc As String Set replacement = CreateObject("vbscript.regexp")...

Hello I want to use back references and regex with Search and Replace, is it possible? Thanks!

When the contents of a cell changes, some strings are highlighted. This part I got working already. Now I added a regex to highlight strings that contain a temperature as well (i.e. 13° or 10°-25°) This part however does not work (no error but just no output) This is what I have so far. This...

Hello, I have just waded into the world of Regular Expressions. I have created a Function (with some googling) that will check if a pattern exists at the start of a string. The function works as anticipated but Im not sure if this pattern is as clean as it could be? The Pattern is...