Page 1 of 1

Help finding a specific value

Posted: Thu May 17, 2018 2:56 am
by RJ
Let's say you have a huge list of text you need to figure out phrase from. You have part of a phrase "Digi**lV*lc*no" but you don't know what's inside the asterisks.

Is there any expression I can use to search an entire piece of text for what that might be?

Re: Help finding a specific value

Posted: Fri May 18, 2018 10:25 am
by DigitalVolcano
You can use regular expressions

[a-zA-Z] will match one letter

[a-zA-Z]+ will match 1 or more letters.

e.g.

Code: Select all

blah[a-zA-Z]blahblah[a-zA-Z]etc

Re: Help finding a specific value

Posted: Sat May 19, 2018 4:29 pm
by RJ
So let's say i'm trying to find out: Di**talV**cano

Would the expression be:

Di[a-zA-Z][a-zA-Z]talV[a-zA-Z][a-zA-Z]cano

Re: Help finding a specific value

Posted: Sat May 19, 2018 7:40 pm
by DigitalVolcano
That should work. You can test it in the Regular Expresssion tester within the program.

Note your example doesn't actually find asterisks, only letters a-z.

To find any character you can use \S

e.g.

Code: Select all

Di\S\StalV\S\Scano