Simplicty and flexibility!
Cart | |
Contact
| Download | Register| Sign In


Function::String

FirstW
FirstW(TEXT VALUE,n)
FirstW("My Text String. My Second Text String.",3)
FirstW(MyTextField,MyWordCount)
FirstW(Concat(Firstname,Lastname),2)

The firstw function extracts a specified number of words from the beginning (left) of a text value.

firstw(FIELDNAME, n) returns the first n words in the field, including intervening punctuation symbols. Leading spaces are treated as delimiters. Trailing spaces are ignored. If there are n or fewer words in the field, firstw returns the original text value.

Parameters


TEXT VALUE

Any text string.

n

Numer of words that you want the function to return from the beginning of TEXT VALUE.

Returns/Result


A text value n words in length.

Examples


Examples


firstw( "4 The People Limited." , 2)

Returns: 4 The,


firstw( "Club ParaDEASE" , 1)

Returns: Club


firstw( ADDRESS , 2)

Returns:The first two words in the ADDRESS field for every record that is processed. If a record contains the value 540 Avenida de los Delfines in the ADDRESS field, the function returns 540 Avenida.

Reference

firstw

Type

Text Function

Purpose

The firstw function extracts a specified number of words from the beginning (left) of a text value.

Syntax

firstw( TEXT VALUE, n)

Returns

A text value n words in length.

Usage

firstw(FIELDNAME, n) returns the first n words in the field, including intervening punctuation symbols. Leading spaces are treated as delimiters. Trailing spaces are ignored. If there are n or fewer words in the field, firstw returns the original text value.

Examples

firstw( "Sapphire International Ltd." , 2)

Returns: Sapphire International,

 

firstw( "Club ParaDEASE" , 1)

Returns: Club

 

firstw( ADDRESS , 2)

Returns:The first two words in the ADDRESS field for every record that is processed. If a record contains the value 540 Avenida de los Delfines in the ADDRESS field, the function returns 540 Avenida.

See Also


FirstLast
LastFirst
MidW
LastW

On the forum about FirstW

[@EOF@]...

Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

How can i delete a Style sheet?...

Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10

I run W7 and since a few days&nbsp;Dataease 8.5 is not starting any more, do you have an idea? i installed it again but that did not help....

Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40

[@EOF@]...

Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10

On the blog about FirstW


dg3_HelpView