TabFile - Copyright (C) 2004-2010, Incode Systems, Inc.
version 1.12.1 www.incodesystems.com mailto:sales1Usage: [Options] MODE FileName[.txt] [OutputFile[.txt]]
TabFile processes tab-delimited text files, reading FileName and
writing to OutputFile. If OutputFile is not given, FileName is
replaced with the TabFile output. If FileName not given, standard
input is used. Use CON to refer to standard input or output.
Options:
-? write this help to the standard output.
-AddOnly only adds columns in NormCols mode.
-c:n defines the ASCII number of the character to escape.
"-df:m/d/yyyy h:nn:ss AM/PM" DateTime Format. Default, use regional settings
(time format may be omitted and m, d, yy, or yyyy in any order)
"-ff:#,##0.00;(#,##0.00);0.00
(format above produces: 1,100.00 for 1100, (1,100.00) for -1100
and 0.00 for 0)
"-ff:Currency (uses the regional settings for currency with default decimals)
"-ff:Currency:4 (uses the regional settings for currency with 4 decimals)
--help open TabFile.htm in the same directory as the program.
-hd modifies ColToRow mode to begin each row with a T (type) column with
a value of H (header) or D (detail).
-sdf:yyyy-mm-dd (changes short date format used to parse dates read from file)
TabFile uses the settings from the control panel by default.
"-stf:h:mm:ss am/pm" (changes short date format used to parse times read from
file) TabFile uses the settings from the control panel by default.
Modes:
AddCol[:Value]
- Adds a blank column, or column containing Value, to the end of each row.
If Value is not given, "EOR" (end of row) is used.
Center[:n[,n]]
- Centers all columns or the columns given.
ColToRow[:n[,n]]
- All columns except those fixed columns given are converted to separate
rows. Two columns named Column and Value are added to the fixed columns.
Fixed columns are written to the output in the order given.
(see -hd option)
DQFix[:n[,n]]
- Removes double quotes from double-quoted columns.
DupCol[:n[,n]]
- Duplicates all or given columns by appending them to the row.
Example DupCol:1,3,5 (duplicates columns 1, 3, and 5)
EncodeHTML[:n[,n]]
- Encodes the columns for HTML.
EncodeJS:[n[,n]]
- Encodes the columns for JavaScript.
EscChar[:n[,n]]
- Escapes all instances of the character by doubling it. The
character escaped is defined in the -c option
FormatFloat[:n[,n]]
- Formats floating point column(s) using -ff format.
- use -ff:currency to format using the regional currency settings.
- If column numbers are not given, only data containing a
decimal point are processed to avoid processing integer data.
FormatDateTime[:n[,n]]
- Formats DateTime column(s) using regional settings or -df format.
LeftJust[:n[,n]]
- Left justifies all columns or the columns given.
NormCols
- Normalizes column count by adding blank columns to rows
containing fewer columns than the header row and skipping
columns not contained in the header row.
RightJust[:n[,n]]
- Right justifies all columns or the columns given.
Select:n[,n]
- Selects columns given.
Transpose
- Rotates a tab file so the rows become columns.
Trim[:n[,n]]
- Trims all columns or the columns given.
(removes leading and trailing spaces and control characters)
TrimLeft[:n[,n]]
TrimRight[:n[,n]]
UpperCase[:n[,n]]
LowerCase[:n[,n]]
TitleCase[:n[,n]]
(first letter of each word is capitalized, others lowercase)
Any operation which includes a column list may be specified
by providing the column number(s) or the column name(s) contained
in the header row, but not mixed (use either all numbers or all names).
Column names must begin with a character >= "A".
A tab-delimited text file containing the column names or numbers
may be used like this: "DupCol:(the file is named
MyFile.txt). A case insensitive comparison to the header row
of FileName is made to determine the columns to process.
Surround any option, mode, or file name containing a space with double quotes
TabFile - Copyright (C) 2004-2010, Incode Systems, Inc.
version 1.12.1 www.incodesystems.com mailto:sales1To see complete usage type: TabFile -? | MORE
To see full documentation type: TabFile --help (or open TabFile.htm)
Incode Systems, Inc.