ipskey table:MATCHDETAILS field:3 file:teams addmissing:SOCCER|NEWTEAM|\ZK|\ZD table:MATCHDETAILS field:4 file:teams default:BING table:COMPETITIONS field:2 file:comps table:COMPETITIONS field:7 lookup:sels lookup:sels Div*1=D1 Div*2=D2 Div*3=D3 Div*4=D4 file:teams keylen:5 keytype:u table: (tablename) (list of table entries ..) (eoln) subkeywords for 'table' are : field: fieldnumber starting at 3 for the first field as the first two are DATABASE|TABLE eg: database| table| field3 field4 SOCCER|MATCHDETAILS|30-9-95|Stirling|Ayr|GOAL|Taggart|18||| file: name of file in tables/skey containing a list of keys and searches lookup: name of a lookup table specified in this parameter file somewhere There can be either a 'file' or a 'lookup' per table but not both. The following are what to do if the field has no match. If nothing is specified, the original data is left. addmissing: add an extra record a (unique) key is determined an entry is added to the file if there is a subparam, it is used to create a output record before this one. addmissing:SOCCER|TMP_TEAM|\ZK|\ZD where ZK is the key and ZD is the data and ZO is the original remember to add dbl quotes if spaces are to be embedded zap: ignore this whole line ! default: make this the default default:**MissingKey** remember to add dbl quotes if spaces are to be embedded default:"** Missing Key **" again field \ZO is available Note that fields ZK, ZD and ZO must NOT have any HASHES (#) as this chr terminates the field. The 'lookup' keyword is specified by : lookup: (tablename) (list of table entries ..) (eoln) eg lookup:abc 1=a 2=b 3=c 4=d 5=e 6=f The list of lookup table entries are a number of entries delimitied by spaces and/or tabs. If embedded spaces/tabs are needed, double quote the entry. The condition is considered passed (or failed if the "!=" is used) if at least one of the entries is matched. The 'file' keyword is used to specify a maximum size and type of key : file: (name of file) keylen: (size) keytype: (type) file is the name of a file in tables/stat/key and has the format (opt spcs) (key) (spcs) (search text) (opt spcs) LIVER Liv*pool - wild cards can be specified using a '*' or a '?'. - embedded spaces and control chrs - use double quotes and/or FipSeq for both key and text - lines may be commented by a leading ';' - The search is assumed to START with the first chr, but the remainder is wildcarded : ALBI Albion will find : Albion Rovers Albion United Albion City but NOT Perfidious Albion - keys can be sized and typed using 'keylen:' and 'keytype:' - size can be 0 for no checking on size - Valid types are : u - uppercase (any lowercase is forced uppercase) l - lowercase (any uppercase is forced lowercase) a - alphabatic x - alphanumeric n - numbers only p - printables (anything above SPC and NOT accented) b - binary anything goes. Other parameters - all optional - are : sep:| Character to use as a field separator default: '|' before: FipSeq string to add BEFORE any data default: none after: FipSeq string to add AFTER any data default: none befline: FipSeq string to add BEFORE each line default: none aftline: FipSeq string to add AFTER each line default: none script: Script to run on the output file. default: none dest: FIP Destination to sent to for spooled default: 'skey' queues. (not that single shot files stay where they are) doneq: For spooled queues, a done queue def: file deleted for the input file. chrset: Chrset for the output file. filename: New filename for output file default: as input fiphdr: Additional FipHdr information default: none Where sections of FipHdr fields are required or changes to the output style, use keywords : fixed, partial, combie, optional, repeat, newdate and/or style. (see The SysAdmin manual for more information). They are normally specified : fixed:QZ 1234543 partial:QT ST,3,2,U,<,> combie:QY ep|na,(0000000)a option:QE ep,11,7,s repeat:QK XK,-,3 or repeat:QP PK,,4,#X style:QS XN,%.03d Where the data lines have the similar information and often the same key, to make things faster, you can cache the results. Beware however if you have similar data - CHESTER and COLCHESTER for example - in this case we recommend you do NOT cache. The default is NO caching. Input Parameters are : EITHER -i : input queue default: spool/statkey If this does NOT start with a '/', it is assumed under spool. OR -1 : name of a single file (complete path pls) default: spooled queue This will run the program once for that file only The input file is NOT deleted. -o : output or done queue for output file. default: spool/2go If this does NOT start with a '/', it is assumed under spool. Any original file in the output queue is overwritten. -z : default parameter file in tables/stat. def: STAT_KEY -w : file wait for files arriving across a network. def: 0 secs -u : owner if not that of the logon default: logon at start -l : do NOT log files in default: log -C : cache results default: no -x : display results default: no -X : display results and prompt on a missing default: no -v : print version number and exit (copyright) 2017 and previous years FingerPost Ltd.