Using Wild Cards

There are 2 different ways in which GOFR does pattern matching – either using wild cards (the same thing that Microsoft Office uses) or Regular Expressions.

Wild Cards are simpler but less powerful.

There are many resources online that you can use to understand wild cards.

This is a good one:

http://word.mvps.org/faqs/general/usingwildcards.htm

To use wild cards in GOFR, in the multiple parameter entry page click the Option menu (OPT) next to the text to find or text to replace text box and select “WildCard”. The background color of the text box will change to yellow.

You can use Wild cards to transform the result based on the search pattern. For example, you can transform a pattern of <First Name> <Last Name> to <Last Name> <First Name>, fix number formatting, etc. Definitely take a look at the link above.

We have also put together a help file on transformation here: "Transform Text With Wild Cards and Regular Expressions"

You can refine a search by using any of the following wildcard characters.

To find Use this Example
Any single character ? s?t finds "sat" and "set."
Any string of characters * s*d finds "sad" and "started."
One of the specified characters [ ] w[io]n finds "win" and "won."
Any single character in this range [-] [r-t]ight finds "right" and "sight" and "tight."
Ranges must be in ascending order.
Any single character except the characters inside the brackets [!] m[!a]st finds "mist" and "most" but not "mast."
Any single character except characters in the range inside the brackets [!x-z] t[!a-m]ck finds "tock" and "tuck" but not "tack" or "tick."
Ranges must be in ascending order.
Exactly n occurrences of a character or expression {n} fe{2}d finds "feed" but not "fed."
At least n occurrences of a character or expression {n,} fe{1,}d finds "fed" and "feed."
A range of occurrences of a character or expression {n,n} 10{1,3} finds "10," "100," and "1000."
The beginning of a word < <(inter) finds "interesting" and "intercept" but not "splintered."
The end of a word > (in)> finds "in" and "within," but not "interesting."