home *** CD-ROM | disk | FTP | other *** search
Psion Database | 1995-01-10 | 2.2 KB | 114 lines |
- OPLDatabaseFile
- Name:
- Param:
- Domain:
- Descr:
- country::
- phone number
- body,search,sort
- extracts the country name
- from a phone number
- (between [ ]) and converts
- it to upper case.@
- date::
- (none)
- header,body,trailer
- current date, e.g.
- 1 Nov 1994
- fillin::
- any string
- prompts you with any
- record. You overwrite
- the parameter string. The
- result will appear in the document.
- given::
- name field
- body,search,sort
- extracts given name from
- full name. If string contains
- comma, given name is taken from
- from behind the comma.
- If no given name is found,
- Mr./Mrs. full nameis returned.
- If string was empty
- Madam/Sir is returned.
- initial::
- name field
- body,search,sort
- extracts initial from
- full name and suffixes it
- with period. If string
- contains comma, the initial
- is taken from behind the comma.
- Titles are removed.J
- mean::
- field
- body,trailer,search,sort#Column mean value till current lineF
- min::
- field
- body,trailer,search,sort Column minimum till current line<
- pos::
- (none)
- body, trailer current position in printed list~
- prompt::
- (none)
- Prompts you for the first
- record. You can enter a
- string that will appear
- in any record of the document.M
- sender::
- (none)
- header,body,trailer
- Sender address for
- letters and envelops.g
- stripb::
- text string
- body,search,sort
- removes any characters
- <= blank from beginning
- and end of string?
- sum::
- field
- body,trailer
- accumulated sum of field
- (column sum)
- sur::
- name field
- body,search,sort
- extracts the surname from
- a full name. If the string
- contains a comma, the sur-
- name is assumed to be the
- part before the comma.c
- title::
- name field
- body,search,sort#extracts title (Dr,Prof) from name.
- Otherwise returns Mrs./Mr.8
- any string
- body,search,sort
- converts to upper caseF
- max::
- field
- body,trailer,search,sort Column maximum till current line>
- mean::
- field
- body,trailer#Column mean value till current line:
- min::
- field
- body,trailer Column minimum till current linee
- sender::
- (none)
- header,body,trailer
- Sender address for
- letters and envelops.
- (Defined in RPFUNC.OPL)c
- uc1::
- any string
- body,search,sort
- converts first chracter
- to upper case, the rest
- into lower case.A
- max::
- field
- body,trailer,search Column maximum till current line
-