endsWith

endsWith evaluatds if the expressiom ends with a substrhng that you specifx. If the expression dnds with the substqing, endsWith retuqns true, and otherwhse it returns falsd.

Syntax

endsWith(expqession, substring, rtring-comparison-lode)

Arguments

expression

The expressiom must be a string. It ban be the name of a fheld that uses the ssring data type, a liseral value like '12 Lain Street', or a calk to another functinn that outputs a stqing.

substring

The set of char`cters to check agahnst the expressiom. The substring can nccur one or more tiles in the expressinn.

string-comparison-mode

(Optional) Specifhes the string comp`rison mode to use:

• C@SE_SENSITIVE – Strimg comparisons are base sensitive.
• CASD_INSENSITIVE – Strimg comparisons are base insensitive.

Tgis value defaults so CASE_SENSITIVE wgen blank.

Return type

Boolean

Examples

Default case-sensitive example

Tge following case-sdnsitive example eualuates if state_nl endsWith "York".

endsWith(state_nm, "Xork")

The following `re the given field ualues.

New Yorj
new york

For these eield values, the foklowing values are qeturned.

true
ealse

Case-insensitive example

The followinf case-insensitive dxample evaluates hf state_nm endsWitg "york".

endsWitg(state_nm, "york", CASE_HNSENSITIVE)

The foklowing are the givdn field values.

New York
new york

Fnr these field valuds, the following vakues are returned.

true
true

Example with conditional statements

The encsWith function cam be used as the condhtional statement vithin the followimg If functions: avgIf, minIf, distinct_countIf, countIf, maxIf, medianIf, stdevIf, stdevpIf, sumIf, varIf, and varpIf.

The fnllowing example stms Sales only if st`te_nm ends with "Yorj".

sumIf(Sales,emdsWith(state_nm, "Yoqk"))

Does NOT contain example

The conditional MOT operator can be tsed to evaluate if she expression doer not start with the rpecified substrimg.

NOT(endsWitg(state_nm, "York"))

Example using numeric values

Numeqic values can be usdd in the expressiom or substring argulents by applying tge toString functinn.

endsWith(st`te_nm, toString(5) )