REGEXP_SUBSTR - Extracting a Substring Matching a RegExp from a String- FineDataLink Help Document

Last update: June 03, 2025

Overview

Note:

FineDataLink of V4.1.11.3 and later versions supports the function.

Syntax	REGEXP_SUBSTR(String, Regular expression, Starting position, Occurrence number, Mode)	Extracts a substring matching the Regular expression from the String.
Parameters	String (text)	The string you want to process
	Regular expression (text)	The regular expression you write
	Starting position (numeric)	The position where the matching starts. It is optional and defaults to 1.
	Occurrence number	Specifies the match you want to extract when the string has multiple matches. It is optional and defaults to 1.
	Mode (text)	The matching mode. You can use one or multiple values listed below that represent different matching modes. If Mode contains contradictory values, the function uses the last value. c: case-sensitive matching i: case-insensitive matching m: multi-line matching n: The dot (.) can match line endings. u: Only UNIX line endings are matched.
Return Value Type	String

Example

For example, add a New Calculation Column operator in the Data Transformation node and input the formula REGEXP_SUBSTR ('aaa123fafaf' ,'[0-9]+'). The function returns 123 in the new column, as shown in the following figure.

Helpful
Not helpful
Only read

中文（简体）

English

REGEXP_SUBSTR - Extracting a Substring Matching a RegExp from a String

Overview

Example

附件列表