This section is an alphabetic list of the currently available CSVfix commands. Each command has one or more examples of how it should be used - see the Usage section for general help on command syntax.
You can also get a list of commands available in your CSVfix executable by entering the following on the command line:
csvfix help
More detailed built-in help is also available. You can get a help summary by entering:
csvfix help command
where command is the actual name of the command you are interested in. This facility is intended as a reminder of command syntax only - the definitive documentation of CSVfix remains this help file.
Note that all CSVfix commands and command line flags are case-sensitive, and should be entered in lower-case. CSVfix supports several command line flags not described in the detailed command pages, as they are available for almost all commands:
Flag |
Req'd? |
Description |
-o filename |
No |
Write output to named file rather than standard output. |
-ibl |
No |
If this flag is used, CSVfix ignores any blank lines in input streams. By default, such lines are not ignored and will result in CSV records consisting of a single empty field being created. |
-ifn |
No |
This flag tells CSVfix to remove a field-name record, which must be the first line in a CSV input file, from output. CSVfix does not check that such a record exists, it merely filters out the first line. This flag has no effect for the commands that do not read CSV input. |
-sep separator |
No |
Specify an alternative CSV record separator. This must be a single character and not be whitespace, alphanumeric or the double-quote. The separator will be used for all CSV input from files or standard input. It will not be used for formatting CSV for output - for that, see the -rsep flag. |
-rsep separator |
No |
As for -sep (with which it is mutually exclusive), but the same separator is also used when writing CSV output. Note that this may make it possible to produce invalid CSV output. |
-osep separator |
No |
Specifies separator to use on CSV output - this setting overrides the -sep and -rsep flags. |
-smq |
No |
By default, CSVfix wraps every CSV output field in double quotes. If you don't want this behaviour, the -smq flag turns on smart quoting, which only double-quotes fields that contain special characters such as commas and quotes. This flag has no effect for the commands that do not produce CSV output. |
-sqf fields |
No |
Specify a list indexes of fields that must be quoted using CSV quoting rules. For example: |
Created with the Personal Edition of HelpNDoc: Easy to use tool to create HTML Help files and Help web sites