+CSVSIGN


Use this parameter to add a sign before a positive number or replace it with a space. This parameter is applicable to the FORMAT CSV and FORMAT DELIMITED options when operating on numerical values having one of the following data types:

CSVSIGN.png

Operands

HYPHEN

(default) Places a hyphen (-) before negative numbers and no character before non-negative numbers

PLUS

Places a hyphen (-) before negative numbers and a plus symbol (+) before non-negative numbers

SPACE

Places a hyphen (-) before negative numbers and a space before non-negative numbers

When you specify +CSVSIGN(SPACE), BMC AMI Unload formats numbers as follows:

Number

Format

Non-negative

bn

Negative

-n

where:

  • b is a blank character.
  • n is a number.

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*