regular expressions

Hi, I'm trying to workout something and in need assistance on setting RegEx pattern. What would the regular expression pattern be if I were to match a certain space in a string. As an example, I have a string: "Mary had a little lamb" And I want to match the closest space to the left...

I am trying to replace " " with a new line in visual basic using regular expressions. I tried to find: ([\s]*)("") and replace with: \n\n. However, in my text is replaced but with "\n\n", not two physical new lines. I also tried to replace it with \r\r, but it does the same.

I've created a userform that allows people to enter their name, an item description and then they can choose two characteristics of their item based on combo boxes on the userform. I then built another userform to allow for finding previous entries and the user would search on the names that...

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

I'm trying to build a sheet that collects addresses I receive from clients about available work throughout the US. This information comes to me via email from different clients. Each client sends me the information in a different format but all of them have the same information. The information...

Hi, I am trying to use RegExp in VBA to find all named ranges in a formula. To find it, I'm basically looking for a string that doesn't end with a ( and that is only made up of a-z, A-Z, 0-9, \, _. I'm a bit confused about atomic groups and look arounds. As far as I understand it...

I have a worksheet that contains 900 rows of text data. In the column some of the text starts with a hyphen and space "- ". The others start with a number or alphabets. I am trying to compare this column to another one and find matches between them using IF(ISERROR(MATCH. I followed the thread...

System.Text.RegularExpressions.Regex -->.Net Framework regular expressions Is it can be used in VBA?

Is there a way to extract all values starting with aa, pt, ra or whatever multiple values starting with defined prefixes into another column. So if aa12345 as12345 root sys aa90231 are in column a I would like to move them into column F or possibly another worksheet. But I would need to...

greetings everyone, here's my situation, i'm trying to rename all the files, folders, subfolders, and also the files inside the subfolders in a path. The files/folders have "14" on their names. my trainer told me that it can be done using regular expressions, but i'm having a hard time...

I am given a spreadsheet with 1 column. In this column, is a long string containing a variable list of gps coordinates. The syntax of the string is always the same, like this: LINESTRING(lat lon, lat lon, lat lon) My problem is that I need to switch each coordinate to be lon lat instead of...

Hey all, in this snippet of code: Set has_parens_with_content = CreateObject("VBScript.RegExp") With has_parens_with_content .MultiLine = False .Global = True .IgnoreCase = True .Pattern = "\([A-Za-z0-9]\)" If has_parens_with_content.test(clean_string)...

Can someone please advise what the correct pattern is to return the text between two search strings? For example, in the html string below, I want to return the text between "selected>" and "<". In this example I want "NA". "<SELECT class=nfinput name=pace0><OPTION value=L>L</OPTION><OPTION...

Hi, Is it possible to used named groups in VBAs version of Regular Expressions (Regexp) Example match groups for extracting dates from strings: (?:(\d{2})\.(\d{2})\.(\d{4})\s(\d{2}):(\d{2}):(\d{2}))|(?:(\d{4})-(\d{2})-(\d{2})\s(\d{2}):(\d{2}) will return DD.MM.YYYY or YYYY-MM-DD in submatch...

Hi, I'm trying to look for some whole-word Unicode words in a range of cells. My lookup words may look something like these: "an" "tiếp" "lị" "nguyễn", etc. (they are made up of characters from the Vietnamese alphabet) and my lookin cells may look something like these: "an" "ban, tiếp; lịn...