Formula LIKE statement?

[khopper]

Is there an option for Formula's similar to the MySQL LIKE statement available or even a work around?

[tanya]

https://www.espocrm.com/documentation/administration/formula/#user-content-stringcontains

[khopper]

string\contains(STRING, NEEDLE) Whether STRING contains NEEDLE. (since version 5.1.2)

Something like this?

string\contains(video, public)

video is my field name and public would be what i'm looking for

[tanya]

here - with quotes (' ') means some string, without - field name

string\contains(video, public) - field video contains a field public
string\contains(video, 'public') - field video contains a word public

[khopper]

Thank you as always for the clarification!

[khopper]

I noticed that it is case sensitive, is there a way to make it not case sensitive?

ifThen (
    client == 'COMCAST' && term == '24 Mo',
    commission = ifThenElse (
        voice == 'New',
        (
            ccblmrc + ccfflmrc + ccmlmrc - discountvoice
        ) * 0.5,
        0
    ) + ifThenElse (
        internet == 'New',
        (ccimrc - discountinternet) * 0.5,
        0
    ) + ifThenElse (
        video == 'New' && (
            string \ CONTAINS (ccbcvideo, 'private')
        ),
        (ccvmrc - discountvideo) * 0.5,
        0
    ) + ifThenElse (
        video == 'New' && (
            string \ CONTAINS (ccbcvideo, 'public')
        ),
        (ccvmrc - discountvideo) * 1.5,
        0
    ) + ifThenElse (
        phonesystemcommission != NULL,
        phonesystemcommission,
        0
    )
);

[tanya]

https://github.com/espocrm/documentation/blob/master/docs/administration/formula.md#stringlowercase

string\contains(string\lowerCase(ccbcvideo), 'public')

[khopper]

Thank you!