DW Find Seach
Return value for DW's Find and Search functions is somewhat ambigous.
When there is no match for FindText in WithinText in DW integrated functions
“Find” and “Search”, return value is #VALUE! It seems the return value cannot be
evaluated!?
If(Search("_",
"How_To get false",
1)
>1 ,TRUE,FALSE) – result: True
If(Search("_",
"HowTo get false",
1)
>1 ,TRUE,FALSE) – result: #VALUE!
Workaround1:
If(SppStringFilter("How_To
get false","_")
<>
"",TRUE,FALSE)
– result:True
If(SppStringFilter("HowTo
get false","_")
<>
"",TRUE,FALSE)
– result:False
Workaround2:
Not(IsError(Find("_","HowTo
get false")))
Workaround3 (if you are
using SWMemRelease Add-on)
|
|
|
|
