<< Click to Display Table of Contents >> Navigation:  Available Functions > But_First()

Syntax

But_First( <CharacterField>, <Delimiter> )

 

Purpose

To extract all but the first word from a field.

 

Parameters

<CharacterField> is the name of any character field in DonorQuest, such as the last or first name field.

 

<Delimiter> is usually a quoted space (" "). In general, <Delimiter> is whatever separates words within the field from which you wish to extract all but the first word. In most cases, words within fields are separated by a space, but you may also have fields in which commas or semicolons are used to separate words or groups of words.

 

Returns

All but the first word from within <CharacterField>.

 

Usage

But_First() can be used with reports to omit the first word from any character field. One possible use of this function would be to design a donation report that would omit the first word of the donation comment field. This could be useful, for example, if you use the donation comment field to store multiple pieces of data, with the first word always being an ID number for an auction item. On DonorQuest reports and exports, you could isolate the other items in the comment from the auction ID using the But_First() function.

 

Example

The following examples illustrate the use of But_First().