|
Specifying
Output Data Format
Most fields in
Microsoft Outlook store simple text data, and CLIPFORM extracts this data as
simple text. However, some Microsoft Outlook data consists of dates and
times, numbers, and boolean (true/false) values. CLIPFORM offers
outstanding flexibility in how to format this data. For each date/time,
boolean or numeric Outlook field, you can optionally follow the field with a
vertical bar and a format specification, as the examples below show.
DATES
AND TIMES
Format strings for
dates and times should be specified as shown below.
| mmmm |
Month (full spelling), e.g. April |
| mmm |
Month (text, abbreviated), e.g. Apr |
| mm |
Month (numeral with leading zero), e.g. 04 |
| m |
Month (numeral without leading zero), e.g. 4 |
| dddd |
Day of the week (full spelling), e.g. Wednesday |
| ddd |
Day of the week (abbreviated), e.g. Wed |
| dd |
Day of the month (numeral with leading zero), e.g. 05 |
| d |
Day of the week (numeral without leading zero), e.g. 5 |
| yyyy |
Year (all digits), e.g. 2001 |
| yy |
Year (two digits), e.g. 01 |
| hh |
Hour (24 hour format) |
| h |
Hour (12 hour format) |
| mm |
Minutes |
| ss |
Seconds |
| ampm |
am or pm (12 hour time format) |
Here are a few
examples of dates and times, along with sample output:
[Start|ddd.
mm/dd/yy h:mm ampm]
Sat. 04/28/01 12:30 pm
[CreationTime|dddd,
mmmm d, yyyy] Saturday, April 28, 2001
NUMBERS
Format strings for
dates and times should be specified as shown below.
| ### |
Digit placeholder; leave blank if no significant digit
present. |
| 000 |
Digit placeholder; include a zero if no significant digit
present. |
Here are a few
examples of dates and times, along with sample output:
[Mileage|$0.00]
$0.23
[Price|$##,###,000.00]
$ 1,214.35
BOOLEAN
(True/False)
With Boolean values,
you have even more flexibility: you can specify the text to use for true values,
and the text to use for false values, separating them with a vertical bar.
If you omit this vertical bar, then no text will be included for false
values. Here are some examples:
[Newsletter|Newsletter]
(Extracts Newsletter if Newsletter is true, nothing if Newsletter is false)
[AllDayEvent|Yes|No]
(Extracts Yes if item is an all day event; No if it is not.)
DURATION
Outlook Appointment
and Journal items feature a Duration field. If you follow this
field with a vertical bar and h:mm, the duration will be extracted in hours and
minutes. If you omit this, duration will be extracted as minutes.
For example, an item of 90 minutes duration would be extracted as follows
[Duration|h:mm]
produces: 1:30
[Duration]
produces 90
SPECIAL
FIELDS
Certain Outlook values
are coded references to items in a list. For example, the Gender property
can be male, female or unspecified. Some of these are automatically
converted by CLIPFORM to the appropriate string:
Sensitivity can
be blank, or can be Personal, Private or Confidential
Status (for
tasks) can be Not Started, In Progress, Complete, Waiting or Deferred
BusyStatus
(for appointments) can be Free, Tentative, Busy or Out Of Office
FlagStatus can
be blank, or it can be Complete; or if an item is flagged, this will
produce the FlagRequest value, if one exists; otherwise it will return Flagged
Certain other items
permit you to specify a string value to correspond with the coded
reference. You do this by including the string values to substitute,
separated by the vertical bar. For example:
| [Gender|Female|Male] |
Extracts the gender, formatting it as Female or Male.
If the gender is unspecified, returns a blank.
|
| [Gender|F|M] |
Extracts the gender, formatting it as F or M.
If the gender is unspecified, returns a blank.
|
| [Importance|Low|Normal|High] |
Extracts the importance. The values shown – Low,
Normal and High – are the Outlook defaults, but you can
substitute anything.
|
|
SOFTWARE