- Bulgarian (Български)
- Chinese Simplified (简体中文)
- Chinese Traditional (繁體中文)
- Czech (Čeština)
- Danish (Dansk)
- Dutch (Nederlands)
- Estonian (Eesti)
- French (Français)
- German (Deutsch)
- Greek (Ελληνικά)
- Hebrew (עִברִית)
- Hungarian (Magyar)
- Italian (Italiano)
- Japanese (日本語)
- Korean (한국어)
- Polish (Polski)
- Portuguese (Brazilian) (Português (Brasil))
- Slovak (Slovenský)
- Spanish (Español)
- Swedish (Svenska)
- Turkish (Türkçe)
- Ukrainian (Українська)
- Vietnamese (Tiếng Việt)
Regular expressions
The table below lists the regular expressions that can be used to create a dictionary for a custom language.
Item name | Conventional regular expression symbol | Usage examples and explanations |
Any character | . | c.t— denotes "cat," "cot," etc. |
Character from group | [] | [b-d]ell— denotes "bell," "cell," "dell," etc.; [ty]ell— denotes "tell" and "yell" |
Character not from group | [^] | [^y]ell— denotes "dell," "cell," "tell," but forbids "yell”; [^n-s]ell— denotes "bell," "cell," but forbids "nell," "oell," "pell," "qell," "rell," and "sell" |
Or | | | c(a|u)t— denotes "cat" and "cut" |
0 or more matches | * | 10*— denotes numbers 1, 10, 100, 1000, etc. |
1 or more matches | + | 10+— allows numbers 10, 100, 1000, etc. |
Letter or digit | [0-9a-zA-Zа-яА-Я] | [0-9a-zA-Zа-яА-Я]— allows any single character; [0-9a-zA-Zа-яА-Я]+— allows any word |
Capital Latin letter | [A-Z] | |
Small Latin letter | [a-z] | |
Capital Cyrillic letter | [А-Я] | |
Small Cyrillic letter | [а-я] | |
Digit | [0-9] | |
@ | Reserved. |
Note:
- To use a regular expression symbol as a normal character, precede it with a back slash. For example,[t-v]x+ stands for tx, txx, etc., ux, uxx, etc., and vx, vxx, etc., but \[t-v\]x+ stands for [t-v]x, [t-v]xx, [t-v]xxx, etc.
- To group regular expression elements, use brackets. For example, (a|b)+|c stands for c or any combinations like abbbaaabbb, ababab, etc. (a word of any non-zero length in which there may be any number of a's and b's in any order), while a|b+|c stands for a, c, b, bb, bbb, etc.
Examples
Suppose you are recognizing a table with three columns: birth dates, names, and e-mail addresses. In this case, you can create two new languages, Data and Address, and specify the following regular expressions for them.
Regular expression for dates:
The number denoting a day may consist of one digit (1, 2, etc.) or two digits (02, 12), but it cannot be zero (00 or 0). The regular expression for the day should then look like this: ((|0)[1-9])|([1|2][0-9])|(30)|(31).
The regular expression for the month should look like this: ((|0)[1-9])|(10)|(11)|(12).
The regular expression for the year should look like this: ([19][0-9][0-9])|([0-9][0-9]).
Now all we need to do is combine all this together and separate the numbers by period. The period is a regular expression symbol, so you must put a back slash (\) before it.
The regular expression for the full date should then look like this:
((|0)[1-9])|([1|2][0-9])|(30)|(31)\. ((|0)[1-9])|(10)|(11)|(12)\.((19)[0-9][0-9])|([0-9][0-9])
Regular expression for e-mail addresses:
[a-zA-Z0-9_\-\.]+\@[a-z0-9\.\-]+
11/2/2018 4:19:18 PM