Using REGEX to find specific style of strings

NeilFisk

I'm new to REGEX and have tried to get this to work, but to no avail. Was hoping someone here could help.

I need to find items that are placed in single qoutes in a string that fall into the following catagories:

LL-LLLL-NNN

LLLL-NNNNN

LLLLL-NNNNN

LLLLLL-NNNNN

LLLLLLL-55555

LLL-NNNNN

where L is a letter and N is a number.

Can someone help?

Thanks!

Regex

Accepted answers

mst3k

\d is a number

[[:alpha:]] is a letter

* means 0 or more of them

+ means 1 or more of them

. means any single character (letter, number, dash, whatever)

i think you can get what you want with a regular formula (though you could also use the Regex Tool)

regex_match([Field1],'[[:alpha:]]+.*[[:alpha:]]*-\d+')

it looks like you can have multiple groups of letters before your numbers, which is why i allowed for the extra .* and [[:alpha:]]* again. then it will work whether extra groups of letters are there or not.

-1 means TRUE

All comments

mst3k

\d is a number

[[:alpha:]] is a letter

* means 0 or more of them

+ means 1 or more of them

. means any single character (letter, number, dash, whatever)

i think you can get what you want with a regular formula (though you could also use the Regex Tool)

regex_match([Field1],'[[:alpha:]]+.*[[:alpha:]]*-\d+')

-1 means TRUE

NeilFisk

The string may have other information before and after, so I would only want what matches. How do I do that?

NeilFisk

I did copy that same code into the REGEX Parse Tool and it worked great. Thanks!

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335