Simplicty and flexibility!


Function::String

FirstLast
FirstLast(TEXT VALUE)
FirstLast("Hilbert Hockenheim")
FirstLast(MyTextField)
FirstLast(Lookup Customer Customername)


The firstlast function converts a text value from the format: LastName, FirstName [M.] to the format: FirstName[M.]LastName. The [M.] is an optional middle initial (or name).

This function is used when names are stored in a single field. The contents of the field are rearranged so the first word (i.e., the last name) becomes the last word in the returned string. If the name is followed by a comma, the comma is deleted.

If there is only one Word the function will do nothing.

Parameters


Text Value

Returns/Result


Thisfunctionis used when names are stored in a single field. The contents of the field are rearranged so the first word (i.e., the last name) becomes the last word in the returned string. If the name is followed by a comma, the comma is deleted.

Examples


Examples


firstlast("Anthony, Susan B.")

Returns: Susan B. Anthony


firstlast("Eliot, T.S.")

Returns: T.S. Eliot


firstlast(FULL NAME)

Returns: Thevaluein the FULL NAME field in the format shown above for every record that is processed. If a record contains thevalueHolmes, Sherlock in the LAST NAME field, thefunctionreturns Sherlock Holmes.


Reference

firstlast

Type

Text Function

Purpose

The firstlastfunctionconverts a textvaluefrom the format: LastName, FirstName[M.] to the format: FirstName[M.]LastName. The [M.] is an optional middle initial (or name).

Syntax

firstlast(TEXT VALUE)

Returns

A textvalue.

Usage

Thisfunctionis used when names are stored in a single field. The contents of the field are rearranged so the first word (i.e., the last name) becomes the last word in the returned string. If the name is followed by a comma, the comma is deleted.

Examples

firstlast("Anthony, Susan B.")

Returns: Susan B. Anthony

firstlast("Eliot, T.S.")

Returns: T.S. Eliot

firstlast(FULL NAME)

Returns: Thevaluein the FULL NAME field in the format shown above for every record that is processed. If a record contains thevalueHolmes, Sherlock in the LAST NAME field, thefunctionreturns Sherlock Holmes.


See Also


LastFirst
FirstW
LastW
MidW
StringFind
StringReplace

On the forum about FirstLast

[@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 FirstLast


dg3_HelpView