STRSAMEEX function
From Microsoft Office ShapeSheet
STRSAMEEX function
Determines whether strings are the same. It returns TRUE if they are the same and FALSE if they aren't. Use this function to compare multi-byte strings or to do comparisons using case rules for a specific locale.
Syntax
|
STRSAMEEX ("string1", "string2", localeID, flag) | |
|
string1 |
The first string to compare. |
|
string2 |
The second string to compare. |
|
localeID |
The locale ID code. |
|
flag |
A bit that specifies the type of comparison. |
Remarks
You can use a combination of any of the following flags with the STRSAMEEX function.
|
Flag |
Description |
|
1 |
Ignore case. |
|
2 |
Ignore non-spacing characters. |
|
4 |
Ignore symbols. |
|
4096 |
Treat punctuation the same as symbols. |
|
65536 |
Don't differentiate between Hiragana and Katakana characters. |
|
131072 |
Don't differentiate between a single-byte character and the same character as a double-byte character. |