How To Export Data Out Of Resource 32000

Data can be exported from sheets in Resource 32000 using four mechanisms:

  1. Drag-and-Drop from the sheet to another application such as Microsoft Excel.
  2. Copy-and-Paste from the sheet to another application such as Microsoft Excel.
  3. Right-Click on the top corner of the sheet and select the “Save…? option.
  4. Use the Resource 32000 “WriteToFile? scripting language command.

This document concerns itself with the format of the output generated if method 3 or 4 is selected from the above list.

The format of a field is determined by a combination of the type of the field and its “FieldMask? value. Fieldmask values can be overridden in the System Control Security program, “Field Security?.

Type of Field Behaviour
Text A blank fieldmask will output the field left-justified and space padded to the length of the field.
An “R? anywhere in the fieldmask will make the field right-justified and space padded on the left to the length of the field.
If the fieldmask begins with a number then the field is space-padded or truncated as necessary to be the size of the number.
For Example 30R would truncate a character field to 30 characters if necessary, right-justifying the result in a 30 character field and space-padding to the left if necessary.
Number Numbers are output right-justified and space padded on the left to the length of the field. Fieldmask is ignored. If the number is too large to fit in the field the field is filled with “#? symbols.
Value By default currency values are output right-justified and space padded on the left to the left of the field. A decimal point is inserted at the appropriate position.
If the fieldmask contains a decimal point the decimal point is omitted in the output.
If the fieldmask begins with a 0 the left-padding is done with zeroes rather than spaces.
Negative numbers are prefixed with a “-“(which uses one of the character spaces, so the largest negative number is 1/10 of the largest positive number).
If the fieldmask begins with a number then the number overrides the field width.
For Example the format 012. would output a number zero padded to 12 characters with the decimal point removed; so if it was applied to the number 12.34 it would become 000000001234.
A number too large to fit in the field will be replaced by “#? symbols filling the field.
Date If the fieldmask is left blank the date is output as it would appear on the screen, left-justified, and space-padded.
Otherwise the fieldmask is interpreted as a format for the C function “strftime?. The format consists of a row of escape sequences which are replaced by parts of the date or literals which are simply copied to the output. The escape sequences are as follows:
%a
Abbreviated weekday name
%A
Full weekday name
%b
Abbreviated month name
%B
Full month name
%c
Date and time representation appropriate for locale
%d
Day of month as decimal number (01 – 31)
%H
Hour in 24-hour format (00 – 23)
%I
Hour in 12-hour format (01 – 12)
%j
Day of year as decimal number (001 – 366)
%m
Month as decimal number (01 – 12)
%M
Minute as decimal number (00 – 59)
%p
Current locale’s A.M./P.M. indicator for 12-hour clock
%S
Second as decimal number (00 – 59)
%U
Week of year as decimal number, with Sunday as first day of week (00 – 53)
%w
Weekday as decimal number (0 – 6; Sunday is 0)
%W
Week of year as decimal number, with Monday as first day of week (00 – 53)
%x
Date representation for current locale
%X
Time representation for current locale
%y
Year without century, as decimal number (00 – 99)
%Y
Year with century, as decimal number
%z, %Z
Time-zone name or abbreviation; no characters if time zone is unknown
%%
Percent sign

For Example
%d%m%Y would give 1st June 2001 as 01062001
%d%m%y would give 1st June 2001 as 010601
%d/%m/%y would give 1st June 2001 as 01/06/01
%d-%b-%Y would give 1st June 2001 as 01-Jun-2001
%Y %B %d would give 1st June 2001 as 2001 June 01