Kbase 16085: Results: How to change or "flip" display of data in a field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Results: How to change or "flip" display of data in a field
How to change the way a field is displayed?
For example:
Fieldname has data stored as "Lastname, Firstname" .
How to get it to display as "Firstname, Lastname" ?
1. Select Fields -> Calculated Fields -> String Function
2. Select Freeform Checkbox (has to be done manually)
3. Enter the following formula where fieldname contains
'last, first'
TRIM(ENTRY(2,fieldname,",")) + " " + TRIM(ENTRY(1,fieldname,","))
This formula uses the comma in fieldname as the separator. The TRIM
function gets rid of any extra leading or trailing spaces.
This will work even if the first and/or last names are multiple words
If the person's name has a suffix,i.e. PhD, III, MD, etc., it will
be dropped.
Progress Software Technical Support Note # 16085