Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I need a function that do like that : if Location like %RESTO%
is there any function that do that?
Thanks
Yes, it should be like this
If(Location LIKE '*RESTO*', TrueCondition, FalseCondition)
Yes, it should be like this
If(Location LIKE '*RESTO*', TrueCondition, FalseCondition)
You can use directly like operation or WildMatch(Location,'*RESTO*')
Can you also use % as wildcard character? From the help:
like | String comparison with wildcard characters. The operation returns a boolean true (-1) if the string before the operator is matched by the string after the operator. The second string may contain the wildcard characters * (any number of arbitrary characters) or ? (one arbitrary character). |
Examples: 'abc' like 'a*' returns true (-1)'abcd' like 'a?c*' returns true (-1) 'abc' like 'a??bc' returns false (0) |
Like others have said, WILDMATCH is the way to go!
If you got the Correct Answer. Please flag the correct answer and helpful
Hello Guys,
Thanks for your reactions ) I appericiate your help. I have an other request, I have a filed TIME on second I would like to convert it into Hours / minute
ANY IDEA please?
May be like this
Time(Time#(Field, 'ss'), 'h:mm') as Field