regex

Dear Forum Members, I apologize if I'm missing something really simple here, but I'm trying to use VBA to test whether a string contains only zeroes. The string can be many zeroes, or one zero, but must only contain zeroes. Here's the code I've been trying. It always tells me that the string...

I use a fairly simple vba routine to extract data from a table contained in an Outlook email body. The result is an array which contains 1 entry with 7 columns for each email. Here is a sample of one entry in the array: arrList(1,1) = "Sent: Monday, August 28, 2017 10:07:28 AM (UTC-06:00)...

Hi, does anyone know if there is a possibility to use REGEX in DAX formulas? Many thanks for you help, Jakub

I've been trying to learn RegEx in Excel 2013 in order to extract certain substrings from long strings of text. The strings are all in the same column and excel sheet. The solution to my problem is probably quite simple one but I can't quite seem to make the operation work. (I also attempted to...

Looking for excel regular expression. After word CEO, pick next number group. Possible number variations: "+358410 34123" or "045-231 442 111" or "+35850-312654" or "010 4444 222"... Example: How to ReGex for CEO's number? Sales Assistant Pamela Jason, pamela@jason.doe tel:010 2230 000 Ceo...

This is an additional question from post. http://www.mrexcel.com/forum/excel-questions/955263-extract-first-numerical-value-left-right-defined-criteria-string-text.html# I am curious on how to get the program to return additional columns if there is another instance of criteria <tbody> A...

I am trying to clean a file with phone numbers that have put in incorrect. I have fixed many issues, text after the phone number, missing parentheses, etc. I am trying to use regex to look for a missing space after the closing parentheses ex. (978)882 What I need the code to do is add a space...

Hi, I'm pretty stuck and no doubt I'll explain this wrong... I'm trying to write a vba scrpt to locate a number pattern that is 3 digits - 7 digits - 7 digits. When found I want to make it a url by adding a web address before it and then adding the original cell value at the end of the url...

I want to fetch data from Google Analytics With M (PowerQuery/PowerBI), but want to filter the dimension values on the fily, Let's Say my dimension is "Page" and I want "Pageviews" and "Unique Pageviews" measures, provided that the "Page" is following a regex filter (ex...

I want to strip all the scripts from a HTML file using regex, that's all script tags and text within the tags , can someone please tell me the correct string pattern to use with vba and regex.

Greetings! As the title states, I would like how to define a pattern to make regex take the text until the first occurrence for a defined character. IE: The useful text is here 'this is garbage 'so is this 'and this is garbage too I tried to define pattern as .Pattern = ".*(?=')" But this...

I am attempting to use a macro to open a text file and search for a match in column d then when the match is found look back in the text file for the MAC address and replace it with the cell value 7 columns over from first match. I will post examples of what I am trying to do. Step 1. look at...

I have a dataset that was created in google docs spreadsheet with a number of regex queries applied to the data. The set has been transferred to an Excel workbook and all outcomes are showing as #NAME rather than a 0,1 coding as they should for the outcome to the work. I don't have access to the...

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, Can anyone please help me in replace the below values (in rows) with space. Actual it looks like : <colgroup><col width="200" style="width:150pt"> </colgroup><tbody> D[24954] Q1 D[24955] Q2 D[24956] Q3 D[24957] Q4...

Hi all, I am trying to search two columns of strings to pick out a reference number. The standard for the reference number has been abused over the years so I'm hoping that someone here could help me with a suitable regex to pick out any one of the possibilities so that I can return the...

Hi! I need some help with regex.. I'm trying to find a solution to extract a set of numbers from a long text. The text might look like: "Blablabla bla bla blablabla 2 blabla bla 44 blablabla 1234567-0100 bla bla blabla" What I need to extract from that text is "1234567-0100" (with the - )...

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...

Hi everybody, I got programming skills, but never had to deal with VBA. I can read it but I can’t do it from scratch. I tried a lot of research but failed to find something that was matching my problem. I understand that my problem must be a classic use case but I couldn’t find the right way...

Hi I pretty much have no prior knowledge to visual basic, or the macro/function in excel for that matter, so bare with me. I'm reading through a MASSIVE chat log that has been imported to excel. The format of the log is like this: (all fictional) <tbody> Timestamp Direction Chat member ID#...