ENDWITH - Determining Whether Text 1 Ends with Text 2- FineDataLink Help Document

Last update: May 30, 2025

Overview

Syntax	ENDWITH(Text 1, Text 2)	Determines whether Text 1 ends with Text 2.
Parameter 1	Text 1	String
Parameter 2	Text 2	String
Return Value Type	Boolean

Notes

Text 1 and Text 2 are case-sensitive.
If any parameter is NULL, the result is NULL.

Example

For example, the following steps describe how to use the function to determine if the Province field ends with "Autonomous Region".

Add a New Calculation Column operator in the Data Transformation node and input the formula ENDWTIH(Province, "Autonomous Region"), as shown in the following figure.

Click Data Preview to view the result, as shown in the following figure.

3.1-3.png

Previous：PROPER - Converting Text Case

Next：STARTWITH - Determining Whether Text 1 Starts with Text 2

Helpful
Not helpful
Only read

中文（简体）

English

ENDWITH - Determining Whether Text 1 Ends with Text 2

Overview

Notes

Example

附件列表