You are here: Field Modifiers > As

As

As is a field modifier that is used to specify a replacement name for an existing field or ad hoc expression.

If As is used in a command that creates a table, the name specified in the As clause becomes the field name in the new table layout. Because the name is a character string, any character expression is valid, provided it adheres to Analyzer’s field naming conventions.

As can be used in command mode only.

Command Mode Syntax

For all commands that output results to a table, the names of the outputted fields can be changed by adding an As modifier after the existing field name followed by the new field name surrounded in quotes:

AS "Replacement_name"

A full command example would be:

EXTRACT FIELDS No AS "Invoice_No" Amount to Exception if Amount>0

When using the Display command, the As field modifier can also be used to write a multi-line column heading to the Command Log. The following Display command displays results of an ad-hoc computed field with the column title “Inventory Value” (the semicolon causes a line break in the column title):

DISPLAY QtyOH*UnCst AS "INVENTORY;VALUE"