REPEAT - Repeating Text a Specified Number of Times- FineDataLink Help Document

Last update: May 30, 2025

Overview

Syntax	REPEAT(Text, Count)	Repeats Text the specified number of times.
Parameter 1	Text	The text to be repeated
Parameter 2	Count	Repetition times

Notes

The function supports two parameters. The first must be of the text type and the second must be of the numeric type.
If any parameter value is NULL, the result is NULL.

Example

Formula	Result	Note
REPEAT("$",4)	$$$$	/
REPEAT(B10,3)	hellohellohello	The content of the cell B10 is hello.

For example, add a New Calculation Column operator in the Data Transformation node, and input the formula REPEAT("$",4), as shown in the following figure.

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

Previous：FIND - Returning the Position of a Specified Substring in a String

Next：CONCATENATE - Joining Two or More Strings into One

Helpful
Not helpful
Only read

中文（简体）

English

REPEAT - Repeating Text a Specified Number of Times

Overview

Notes

Example

附件列表