Page 1 of 1
Search for two or more words
Posted: Wed Sep 16, 2009 2:55 pm
by Stanley
how do I configure regular expressions to search for more than one word
either this word or that word or this word and that word
Posted: Wed Sep 16, 2009 3:26 pm
by DV
You can use the | symbol
Regex - hello|goodbye
This searches for hello or goodbye.
Posted: Wed Sep 16, 2009 7:07 pm
by Stanley
Thanks that worked�
()
Posted: Wed Sep 16, 2009 7:27 pm
by Stanley
Thanks that worked�
()
Posted: Wed Sep 16, 2009 9:59 pm
by Stanley
Thanks that worked
How can I use this syntax to perform a search that shows only the results with both words in a file?
If both words do not exist in the file it should not be shown
Example: Hello and goodbye
Is there a list of examples with the proper syntax?
Posted: Thu Sep 17, 2009 10:28 am
by DV
(hello[\s\S]*goodbye)|(goodbye[\s\S]*hello)
The above will find files with both words in. You wouldn't use it to replace though as it would replace everything between the words as well.
The TextCrawler docs list the syntax (Help menu), but for more friendly examples of regular expressions you could try here -
http://www.regular-expressions.info/tutorial.html
Remember the reg ex test tool is textcrawler is handy for trying things out.
Posted: Mon Aug 09, 2010 5:50 pm
by Vikas
How can search
to_char(<variable>,'000');
Posted: Mon Aug 09, 2010 7:33 pm
by james
This will do it:
(Regular Expression mode)
to_char\((.*),'000'\);