Function::String

FirstC

FirstC(TEXT VALUE,n)
FirstC("Your name",4)
FirstC(MyField,MyStringLength)
FirstC(Lookup MyCustomer CustomerName,TitleLength)

The firstc function extracts a specified number of characters (n) from the beginning (left) of a text value.

Leading blanks are included in the count of characters (n).

Parameters

TEXT VALUE

Any Text value i.e a Field, "string" etc.

The number of characters from the beginning of the string that you want the function to return.

Returns/Result

A text string n characters in length from the beginning of the string inputted.

Examples

Examples

firstc ( "Sapphire International Ltd." , 8)

Returns: Sapphire

firstc ( "Club ParaDEASE" , 6)

Returns: Club P

firstc ( LAST NAME, 4)

Returns: The first four characters

Reference

firstc

Type

Text Function

Purpose

The firstc function extracts a specified number of characters (n) from the beginning (left) of a text value.

Syntax

firstc( TEXT VALUE, n)

Returns

A text string n characters in length.

Usage

Leading blanks are included in the count of characters (n).

Examples

firstc ( "Sapphire International Ltd." , 8)

Returns: Sapphire

firstc ( "Club ParaDEASE" , 6)

Returns: Club P

firstc ( LAST NAME, 4)

Returns: The first four characters

Function::String

Parameters

Returns/Result

Examples

Reference

firstc

Type

Purpose

See Also

On the forum about FirstC

On the blog about FirstC