Difference between revisions of "Manuals/calci/EXACT"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
<div style="font-size:30px">'''EXACT(t1,t2)'''</div><br/> | <div style="font-size:30px">'''EXACT(t1,t2)'''</div><br/> | ||
*<math>t_1</math> and <math>t_2</math> are text string. | *<math>t_1</math> and <math>t_2</math> are text string. | ||
− | |||
==Description== | ==Description== | ||
Line 7: | Line 6: | ||
*This function will give the result in a logical values. | *This function will give the result in a logical values. | ||
*The result is TRUE when the two strings are similar and the result is FALSE when the two strings are different. | *The result is TRUE when the two strings are similar and the result is FALSE when the two strings are different. | ||
− | *<math>EXACT</math> function is the similar to the | + | *<math>EXACT</math> function is the similar to the comparison operator (==). |
*So we can use the operator(==) instead of this function. | *So we can use the operator(==) instead of this function. | ||
*The string values we have to give with in double quotas. | *The string values we have to give with in double quotas. | ||
==Examples== | ==Examples== | ||
− | #EXACT("life","life")=TRUE | + | #EXACT("life","life") = TRUE |
− | #EXACT("life",Life")=FALSE | + | #EXACT("life",Life") = FALSE |
− | #EXACT("LIFE",Life")=FALSE | + | #EXACT("LIFE",Life") = FALSE |
− | #EXACT("l ife","life")=FALSE | + | #EXACT("l ife","life") = FALSE |
− | #EXACT("45","45")=TRUE | + | #EXACT("45","45") = TRUE |
− | #EXACT("7","-7")=FALSE | + | #EXACT("7","-7") = FALSE |
− | |||
==See Also== | ==See Also== | ||
*[[Manuals/calci/LEN | LEN ]] | *[[Manuals/calci/LEN | LEN ]] | ||
*[[Manuals/calci/LENB | LENB ]] | *[[Manuals/calci/LENB | LENB ]] | ||
− | |||
==References== | ==References== |
Revision as of 00:31, 24 January 2014
EXACT(t1,t2)
- and are text string.
Description
- This function checks the two text string values are identical or not.
- This function will give the result in a logical values.
- The result is TRUE when the two strings are similar and the result is FALSE when the two strings are different.
- function is the similar to the comparison operator (==).
- So we can use the operator(==) instead of this function.
- The string values we have to give with in double quotas.
Examples
- EXACT("life","life") = TRUE
- EXACT("life",Life") = FALSE
- EXACT("LIFE",Life") = FALSE
- EXACT("l ife","life") = FALSE
- EXACT("45","45") = TRUE
- EXACT("7","-7") = FALSE