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

Function::String

Proper



Parameters


Returns/Result


Examples


Reference

proper

Type

Text Function

Purpose

The proper function converts the first letter in each word in a text value to uppercase.

Syntax

proper( TEXT VALUE)

Returns

The specified text value with the first letter in each word capitalized.

Usage

Any letter preceded by a space, hyphen, ampersand, or a period is capitalized by the proper function as is the first letter in a parenthesized value. Other punctuation, including the apostrophe, does not act as a delimiter for the proper function.

If you enter a capital letter in a position that is not the first letter in the word or specified value, it remains in uppercase when the value is processed by the proper function.

To capitalize the first character of each word and force all other characters to lower-case, use the lower function in conjunction with the proper function as follows:

proper ( lower ( LAST NAME) )

The proper function is commonly entered as the Derivation Formula for Text fields during Form Definition. For example, if the derivation for the LAST NAME field is:

 

proper(LAST NAME)

 

DataEase follows the rules listed above to capitalize the values entered in the LAST NAME field.

Examples

proper( "playa blanca" )

Returns: Playa Blanca

 

proper( "sapphire international" )

Returns: Sapphire International

 

proper( FULL NAME)

Returns: The value in the FULL NAME field in the proper format for each record processed. For example, if a record contains the value roger birnbaum, the function returns Roger Birnbaum.

See Also


On the forum about Proper

Document Properties - Clear Form after entering a record

When entering a record via a form, it is useful to be able to "Clear form after entering a record". Equally useful is the option to Confirm changes. Whilst I can get "Clear form" to work, I cannot get the confirm changes to pop up. Is it...

Product: Dataease [{8}]FIVE. Written by Kensington 03/09/13 at 12:36:53

Re:Document Properties - Clear Form after entering a record

Further to my comment above re Confirm Changes option, I have discovered that it does work if you first go to a related file by pressing F10 and ( without entering anything ) close it and then return to the main form and press F4. In this case DE8...

Product: Dataease [{8}]FIVE. Written by Kensington 03/09/13 at 14:18:06

Text Field will not go in (Proper) or (Upper) case

My Field Company and Town will not change to Upper case. Some fields do but a couple don't. Any fix or work around appreciated....

Product: Dataease [{8}]FIVE. Written by Dave Clements 12/12/14 at 20:03:52

Re:Text Field will not go in (Proper) or (Upper) case

Is the fields read-only or virtual and what is the derivation?...

Product: Dataease [{8}]FIVE. Written by DataEase 12/12/14 at 22:16:22

Re:Re:Text Field will not go in (Proper) or (Upper) case

Plain text field - Required and Indexed - derivation -   proper (cotown)    some other fields in the form work but at least two don't. ...

Product: Dataease [{8}]FIVE. Written by Dave Clements 12/12/14 at 22:20:46

Re:Re:Re:Text Field will not go in (Proper) or (Upper) case

Proper will only make the first letter Capital so: dAVE would be DAVE and dave would be Dave and DAVE would still be DAVE. In these cases we need to see a sample that showcase the problem as anything else would just be guessing. A...

Product: Dataease [{8}]FIVE. Written by DataEase 12/12/14 at 22:28:40

Re:Re:Re:Re:Text Field will not go in (Proper) or (Upper) case

Done all that but still doesn't work. Works on most fields but three it doesn't. ...

Product: Dataease [{8}]FIVE. Written by Dave Clements 13/12/14 at 11:22:13

Re:Re:Re:Re:Re:Text Field will not go in (Proper) or (Upper) case

OK! We love it when you guys think we are psychics but sorry, can’t do anything about it without seeing it so either you need to upload a sample that show it here, or you need to figure it out on your own ;-)...

Product: Dataease [{8}]FIVE. Written by DataEase 13/12/14 at 11:41:35

Re:Re:Re:Re:Re:Re:Text Field will not go in (Proper) or (Upper) case

Here is a screen shot, full database is very large and sample wouldn't work as some fields it works on. See company town and postcode fields. ...

Product: Dataease [{8}]FIVE. Written by Dave Clements 13/12/14 at 11:49:57

Re:Re:Re:Re:Re:Re:Re:Text Field will not go in (Proper) or (Upper) case

Thanks for that, but the problem wasn't that I didn't belive you ;-)Obviously if I try to replicate it, I don't get a problem...So if you can't send anything, then you simply need to test.Change the length of the field or somet...

Product: Dataease [{8}]FIVE. Written by DataEase 13/12/14 at 12:18:56

On the blog about Proper

New Release of 8.5 - Toolbars etc. now properly sorted and virtual Forms (Ver. 8.5.0.2222)

If you have been using the later releases of DataEase 8.5 and experimented with switching on/off toolbars/tabbars etc you might have experiences some peculiar behaviour....</p...

Product: Dataease [{8}]FIVE. Written by DataEase 11/03/16 at 12:14:27