StringLeft (FPScript)

21.09.2021

Takes a substring out of a string starting from the left.

Syntax

StringLeft(String, Length)

 

The syntax of the StringLeft function consists of the following parts:

Part

Description

String

String from which a substring is to be taken.

Permitted data structures are scalar value, data series und data matrix. Supported data types are string.

Length

The length of the substring.

Permitted data structures are scalar value, data series und data matrix. All integral data types are permitted.

Remarks

The data type of the result is always string.

The structure of the result corresponds to that of the argument String.

If the length specified exceeds the length of the string, the complete string is passed. If the length is less than or equal to zero, an empty string is passed.

If the String argument is a data series or data matrix, the calculation is performed on a per-element basis and the result is either a data series or a data matrix. If the Length argument is a data series or data matrix, then the Length must match the String argument in the number of rows and, if applicable, number of columns.

If an argument is a list, then the first element in the list is taken. If this is also a list, then the process is repeated.

Available in

FlexPro Basic, Professional, Developer Suite

Examples

StringLeft("This is an example", 4)

Returns the substring "This".

StringLeft({"2014-04-22", "2015-04-19", "2016-04-28"} , 4)

Results in the data series {"2014", "2015", "2016"}.

Dim names = {"M75_Val", "M633_Val", "M11850_Val"}
Dim pos = StringFind(names, "_")
return StringLeft(names, pos)

Results in the data series {"M75", "M633", "M11850"}.

See Also

StringRight Function

StringMid Function

StringFind Function

StringReverseFind Function

StringConcat Function

Share article or send as email:

You might be interested in these articles

Weisang GmbH

Sophie-Krämer-Straße 13
D-66386 St. Ingbert
Germany

Tel. +49 6894 929600
Fax. +49 6894 92960 26

Company