Till innehåll på sidan

Nyckelord med långa texter (256 per rad)

The PC-Axis file format consists of a number of keywords. The following are the keywords that can have long texts. If the text is longer then 256 chars it is divided into several lines and each line is within quotation marks. The last line ends with a semicolon.

For all footnotes (NOTEX, NOTE, VALUENOTEX, VALUENOTE, CELLNOTEX, CELLNOTE) the following applies:

The sign # is used to indicate new line, to get a new paragraph use ##. Each text line is within quotation marks, which means that the text itself cannot contain quotation marks.

BASEPERIOD

Base period for, for instance index series. Is shown with the footnote. If there is a contents variable the keyword is repeated for each value of the contents variable.

CELLNOTE

Footnote for a singe cell or a group of cells. Which cell it refers to is given by values and variables. If a value is given as * the note refers to all values for that variable. Only one value can be given for each variable. The values are given in the variable order indicated by STUB and HEADING, starting with STUB.
CELLNOTE("*","*","Stockholm","1995")="Text for footnote for Stockholm 1995";

CELLNOTEX

As CELLNOTE but shown mandatory as for NOTEX.

CONTACT

States the person who can give information about the statistics. Is written in the form name, organization, telephone, fax, e-mail. Several persons can be stated in the same textstring and are then divided by the #-sign. Is shown with the footnote. If there is a contents variable the keyword is repeated for each value CONTACT("value")="xx".

DATABASE

The name of the database from where the statstics is retrieved. Is shown with the footnote.

DESCRIPTION

If a file contains DESCRIPTION, when fetching from a disk, this text is used to show the contents of the disk. Compare keyword TITLE.
If the user wants to save a file in PC-AXIS and writes a text that describes the file, this text will be saved as DESCRIPTION. The text will be used to show the contents of tables. The text is not presented as a note nor in any other way when the table is presented on the screen unless the keyword Descriptiondefault is used. In this case the description is shown instead of the title.
In PX-Web description can be shown if the installation uses that parameter.

INFO

This keyword is read and saved in the PX-file but not shown in PC-axis.

INFOFILE

Name (without extension) of a file containing more information for the statistics. If the keyword exists in the file a new button is shown in the toolbar and the user can click for more information. Depending on the file type and to which program the type is associated the corresponding program is started and the information shown. (Word for .DOC, Notepad for .TXT etc.).

NOTE

Contains a footnote which is shown in the statistical databases if the user demands it. In PC-AXIS it is shown if the user presses F7. The footnote may either refer to the entire table or to a table variable. In the latter case the key word must be followed by the variable name in parentheses.
NOTE="text for note for table";
NOTE("region")="text for note for the variable region";

NOTEX

Contains a note which is always shown in the statistical databases. In PC-AXIS the note is shown automatically, before the table is presented on the screen. The note may either refer to the entire table or to a table variable. In the latter case the key word should be followed by the variable name in parentheses.

REFPERIOD

Text with information on the exact period for the statistics. Is shown with the footnote. If there is a contents variable the keyword is repeated for each value of the contents variable.

SOURCE

States the organization which is responsible for the statistics. Is shown with the footnote.

TITLE

The title of the table, reflecting its contents and variables. If the file contains DESCRIPTION, the text belonging to description is used instead of title. How the title of a table will look depends on which variables the user chooses; the text thus created will then be saved as TITLE. (Compare also Descriptiondefault)
If the file contains DESCRIPTION the text for this key word will be used.

VALUENOTE

A footnote for separate variable values. Should be written with the variable name and the value names in parentheses.
VALUENOTE("region","Stockholm")="Text for footnote for Stockholm";

VALUENOTEX

Mandatory footnote for single values for a variable. Is written with the variable name and the value name in parentheses. Is shown the same way as NOTEX.