The money command allows you to format CSV numeric fields as if they were currency amounts. For example, if you had a field containing the value 12400.6, and applied money formatting to it, the resulting field would be a string containing the value "12,400.60". The money command will only format decimal money amounts - i.e. the currency must follow the dollar and cents model.


See also: number


Flag

Req'd?

Description

-f fieldlist

No

Specifies a comma-separated list of field indices identifying the fields in the input which will be formatted. If this is omitted, all fields will be formatted.

-r

No

Replace input fields with output - default is to append formatted fields.

-db chr

No

Specify decimal point character - default is "."

-ts chr

No

Specify thousands separator - default is ","

-cs sym

No

Specify currency symbol which will prefix the amount - default is none.

-ms minus

No

Specify string to use to indicate negative amounts - default is "-"

-ps plus

No

Specify string to use to indicate positive amounts - default is none.

-w width

No

Specify width of output field in which amount will be right-aligned - default is not to do alignment.

-cn

No

Treat the amount being formatted as in integer number of cents by dividing it by 100 before formatting.



Created with the Personal Edition of HelpNDoc: Produce online help for Qt applications