Incode Systems Home Page Incode Systems, Inc.


TabFile



(Windows 95 or higher command line utility)

- Copyright (C) 2004-2013, Incode Systems, Inc.
Version 1.26.0 www.incodesystems.com mailto:sales1[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.

FileName rows are assumed to be ASCII 10 delimited. ASCII 13 is
ignored, so LF or CRLF files may be read, OutputFile is delimited with CRLF.

If a column is double quoted, it may contain embedded Tab, CR, and LF.
Embedded double quotes are escaped by doubling them (ex: "A ""B"" C").
(except for DQEsc and Sort, when +n option is used)

Options:
-? write this help to the standard output.
-+n (sort using nth character in the line).
Lines are read ASCII 10 delimited, double quotes are ignored.
Use -+1 to sort file using entire line but ignore double quotes.
-AddOnly only adds columns in NormCols mode.
-c (case sensitive)
-c:A defines A as character for modes which use a character.
-c:### defines the ASCII number of a character (ex: -c:032 for space)
(-c is used in modes: EscChar, CatCols, Center, LeftJust, RightJust)
"-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)
-do (detail only in HTMLTable)
"-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)
-fpn:n sets page number of first page for TabToPrt (default=1), 0 for none.
-h- (no header row. Default is file contains header row)
--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).
-htmlattrib: (defines HTMLTable attributes in table tag)
example: "-htmlattrib:cellspacing=0 rules=all" (add border and rules)
-htmlcols:L100,R125,C150 (defines column alignment and width for HTMLTable)
-htmlhead: (defines HTMLTable table heading)
-lpp:n set lines per page for TabToPrt (default=60), 0 for no page breaks.
-tmgn:n set top margin for TabToPrt (default=3)
-lmgn:n set left margin for TabToPrt (default=8)
-p:n defines first column position for SubStr mode.
"-PgHead:My Page Header" for TabToPrt (default=FileName with timestamp)
-r (reverse sort)
-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.
-w:n defines column width for modes: Center, LeftJust, RightJust, SubStr.

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.
Avg[:n[,n]]
- Adds a row with the averages of the columns.
- Use -ff option to specify a format. -ff:currency for currency setting.
CatCols[:n[,n]]
- Concatenates all columns or the columns given and appends as new column.
- Use -c option to define a separator character, like -c032 for space.
Center[:n[,n]]
- Centers all columns or the columns given.
- Use -c option to define padding character (default is space).
- Use -w option to define column width (default is widest).
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)
Count[:n[,n]]
- Adds a row with the count of non-blank columns.
CSVToTab
- Converts Comma Separated Variable (CSV) to tab-delimited.
DecodeJS[:[n[,n]]
- Decodes the columns (JavaScript encoding).
(ASCII: 0=(or DQAdd)
- Add double quotes to columns containing double quotes.
- Escape embedded double quotes by doubling them.
- Lines are read ASCII 10 delimited, double quotes are ignored.
DQUnEsc[:n[,n]]
- Remove double quotes from double quoted columns.
- Unescape embedded doubled double quotes.
DQRemove[:n[,n]]
- Removes double quotes from double-quoted columns.
- Replaces doubled double quotes with a single double quote.
- Replace embedded TAB, LF with space, remove CR.
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.
EscBarCode[:n[,n]]
- Escapes all non-barcode characters with % followed by 2 digit hex ASCII
number. Barcode characters are: (space),$ * + - . / 0..9 A..Z a..z
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.
HTMLTable
- Converts file to HTML table for inclusion in an HTML file.
- options: -htmlattrib, -htmlcols:, and -htmlhead: may be used.
LeftJust[:n[,n]]
- Left justifies all columns or the columns given (see Center for details).
LowerCase[:n[,n]]
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.
Pivot:p,c,n
- Rotates rows to columns
- p is the pivot column
- c is column containing the values that will become new column headings
- n is column containing the values that will become new column values
RightJust[:n[,n]]
- Right justifies all columns or the columns given (see Center for details).
Select:n[,n]
- Selects columns given.
Sort[:n[,n]]
- Sorts tab file by columns given. Use -r option sort in reverse order.
SplitFileName[:n]
- Splits file name in column n (default = 1) appending columns:
FileDrive, FilePath, FileName, FileExt.
SubStr[:n[,n]]
- Makes the column(s) a substring of itself.
- Use -p option to define first position (required).
- Use -w option to define substring length (default is full length).
Sum[:n[,n]]
- Adds a row with the sums of the columns.
- Use -ff option to specify a format. -ff:currency for currency setting.
TabToCSV
- Converts tab-delimited to Comma Separated Variable (CSV).
TabToPrt
- Converts tab-delimited to a print file.
TitleCase[:n[,n]]
- First letter of each word is capitalized, others lowercase
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]]
TrimFile
- Trims blank columns from the right side of each row and empty
rows from the bottom of the file.
Underline[:n[,n]]
- Adds an underline row.
- Use -c option to define underline character (default is -).
- Use -w option to define column width (default is widest).
UnEscBarCode[:n[,n]]
- Reverse of EscBarCode
Unpivot:p
- Rotates columns to rows
- p is the pivot column
UpperCase[:n[,n]]

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".
If mode is followed by [:n[,n]], default is all columns.
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-2013, Incode Systems, Inc.
Version 1.26.0 www.incodesystems.com mailto:sales1see complete usage type: TabFile -? | MORE
To see full documentation type: TabFile --help (or open TabFile.htm)