JDN XP Toolkit 1.14
| Home | Summary of Commands |
You are here: Home
REFERENCE LIST OF COMMANDS AND FILTERS
DAB - delete all blanks
DLB - delete leading blanks
DMB - delete multiple blanks
DTB - delete trailing blanks
DAS - delete all specified strings
DLS - delete leading specified strings
DMS - delete multiple specified strings
DTS - delete trailing specified strings
DAT - delete all trim
DLT - delete leading trim
DMT - delete multiple trim
DTT - delete trailing trim
APP_L_L - extract substring from left end of each rec
APP_L_R - extract substring from right end of each rec
APP_R_L - extract substring from left end of each rec
APP_R_R - extract substring from right end of each rec
DEL_LFP - delete text from I2 rec using I1 rec as search string - delete from left end - limit N1 thru N2
DEL_LIP - delete a string from left end of every I1 rec by matching it to Sub - limit N1 thru N2
DEL_LO - delete Nth field from left end of each I1 rec using specified separator
DEL_LP - delete the contents of pos N1 thru N2 from left end of every rec in file I1
DEL_RFP - delete text from I2 rec using I1 rec as search string - delete from right end - limit N1 thru N2
DEL_RIP - delete a string from right end of every I1 rec by matching it to Sub - limit N1 thru N2
DEL_RO - delete Nth field from right end of each I1 rec using specified separator
DEL_RP - delete the contents of pos N1 thru N2 from right end of every rec in file I1
DEL_NUL - delete null lines (zero length) from input file I1
GET_LO - get Nth field from left end of rec
GET_LP - get substring between pos N1 and N2 from left end of rec
GET_RO - get Nth field from right end of rec
GET_RP - get substring between pos N1 and N2 from right end of rec
INS_LFO - insert rec from I1 file into rec from I2 file into field N from left end
INS_LFP - insert rec from I1 file into rec from I2 file into pos N from left end
INS_LIO - insert inline string into each rec of input file in pos N from left end
INS_LIP - insert inline string into each rec of input file in pos N from left end
INS_RFO - insert rec from I1 file into rec from I2 file into field N from right end
INS_RFP - insert rec from I1 file into rec from I2 file into pos N from right end
INS_RIO - insert inline string into each rec of input file in pos N from right end
INS_RIP - insert inline string into each rec of input file in pos N from right end
SET_LFO - change each I2 rec using each I1 rec in field N from left end
SET_LFP - change each I2 rec using each I1 rec in pos N from left end
SET_LIO - change each I1 rec using an inline string in a field N from left end
SET_LIP - change each I1 rec using an inline string in a pos N from left end
SET_RFO - change each I2 rec using each I1 rec in field N from right end
SET_RFP - change each I2 rec using each I1 rec in pos N from right end
SET_RIO - change each I1 rec using an inline string in a field N from right end
SET_RIP - change each I1 rec using an inline string in a pos N from right end
REP_L - replace leftmost occurrence of S1 with S2 within N1 thru N2 (same as REP)
REP_R - replace rightmost occurrence of S1 with S2 within N1 thru N2
REP_POS - delete the contents of cols N1 thru N2 and replace with Sub
HI - converts a record to all upper case
LO - converts a record to all lower case
INV - invert upper case to lower case and lower case to upper case
INV_CAP - invert capitalization - if a word is capitalized, change it to lower case & vice versa
CAP - capitalize every word in every record
SEN - adjust capitalization of file to appear as English sentences - 1st letter of sentences capped
JUS_L - left justify every record to a specified length
JUS_R - right justify every record to a specified length
PAD_L - left pad string with substring as many times as it takes - N is total length
PAD_R - right pad string with substring as many times as it takes - N is total length
DUPL - duplicate each record a specific number of times
DUP - list duplicate records - list only one name for each group
DUP_A - list duplicate records - list all dupe names
DUP_L - list duplicate records using Nth field from left
DUP_R - list duplicate records using Nth field from right
DUP_AL - list all duplicate records - use Nth field from left end of record
DUP_AR - list all duplicate records - use Nth field from right end of record
UNI - extract unique records from a text file - assumes it is sorted.
REV - reverse the contents of every record in a file - e.g. "hello there" -> "ereht olleh"
FILE_NAME - extract file name from a full file name (e.g. extract "doc.txt" from "C:\MyApp\MySub\doc.txt")
MAT - match a selector (index) file to an input file
MOD - extract a range of records that meet a specified mod condition (e.g. records 3, 6, 9, etc.)
ROW - extract a range of recs between a starting and ending rec number (e.g. records 100 through 200)
COL - extract a substring in specified start & end pos (e.g. COL 2 4 extracts "BCD" from "ABCDE)
NUM - insert numbers into a text file
SEL - select recs - SEL is an enhanced version of the FINDSTR filter
EXT - extract specified rows & columns from specified records from input file
NIT - knit together several files into a single output file - but sideways
ANY - find files containing a list of strings anywhere in a single file
ALL - find files containing a list of strings all on the same line in a single file
REP - replace or insert a search string with a target string in one or more files
INS - insert one file into another following lines that match a search string
PARMS - construct a text file from a number of command line parameters� Copyright JDN Toronto, 2002-2004 - All rights reserved