Using Regular Expression - Parse

Question

I have a set of data that is pulled from a website that is in between two specific blocks of characters: 1,911 181 828 440 106 2,213 1,285^[4] I want to set up a RegEx that pulls anything between a ">" and a "<", so it returns the numbers in the middle of the 's. I know I could do text to columns, but I want to learn the syntax behind RegExpressions better. Is there a way to set it up so that it returns just the digits and comma in between the > and

BenMoss · Accepted Answer

Below is a syntax I used to perform a similar task last week <(\<\w+\>)>(.+)> With the mode set to parse. In my version the value within the open tags declared the header for the value. That does not seem to be the case in yours so I would ammend the statement to read... <\<\w+\>>(.+)> Ben

LordNeilLord · Accepted Answer

Hey @jmilller2018 I'd use a regex function like this: (.*?)<.*\/td> I'm no expert in regex but this works in your example