Easy to Create, Easy to Change - Easy to use!

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.

n

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

See Also


FirstW LastC LastW MidC MidW TextPos

On the forum about FirstC

On the blog about FirstC