like

[master_student]

Hello Guys,

I need a function that do like that : if Location like %RESTO%

is there any function that do that?

Thanks

[sunny_talwar · Accepted solution]

Yes, it should be like this

If(Location LIKE '*RESTO*', TrueCondition, FalseCondition)

[Anil_Babu_Samineni]

You can use directly like operation or WildMatch(Location,'*RESTO*')

[stigchel]

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)

[Anonymous]

Like others have said, WILDMATCH is the way to go!

[Anil_Babu_Samineni]

If you got the Correct Answer. Please flag the correct answer and helpful

[master_student]

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?

[sunny_talwar]

May be like this

Time(Time#(Field, 'ss'), 'h:mm') as Field