Some of the routines contained in TDFUNC.SQC are merely simulations of existing
SQR Functions. For example, PAD-Func is a reproduction of LPAD/RPAD and the
TRIM is a reproduction of LTRIM/RTRIM. While these may not be very useful
from a practical standpoint they are good demonstrations of custom functions.
There are very useful functions in TDFUNC.SQC that perform various string
handling and conversion tasks. You can find full documentation for each function
within the SQC source code. Visit this page often... new functions will be added
periodically... If you have an idea/suggestion for a new function please forward
it to tdelia@erols.com (or click on the Octopus
furthur below).
Some of the Functions listed below will be featured in another page... Click on the
hyperlink for highlights of the function which include usage, coding and samples...
plus I'll add more pictures (which may be my primary motivation for more pages).
Some functions contained in TDFUNC.SQC are variations or modified versions
of those found from sources such as the SQR User's Group... two in particular
are enhanced versions of routines posted by Ray Ontko (BASE-Func) and
Cherno Jagne (BOOL-Func)... visit www.sqrug.com for
more useful material...
| PAD-Func |
Pad String with Character
(LPAD/RPAD) |
| TRIM-Func |
Trim Characters from String
(LTRIM/RTRIM) |
| CF-Func |
Return Ceiling/Floor for Number
(CEIL/FLOOR) |
| INSTR-Func |
Find Position in String (INSTR)
Bi-Directional |
| LIKE-Func |
Simulate Oracle LIKE Function
(pattern matching) |
| REPL-Func |
Replace Characters in String |
| XLT-Func |
Translate Characters in String |
| STRIP-Func |
Strip Characters from String |
| REV-Func |
Reverse Characters in String |
| CTR-Func |
Count Number of Occurances in
String |
| NXT-Func |
Increment Alpha-Numeric String |
| NAME-Func |
Parse Name into Last/First
(PeopleSoft Format) |
| UL-Func |
Upper/Lower Case String
Conversion |
| NL-Func |
Numeric to String Literal
Translation (Pay Checks) |
| NUM-Func |
Numeric Validation/Conversion |
| RND-Func |
Incremental Rounding |
| MON-Func |
Month Conversion (NUM to LIT /
LIT to NUM) |
| JULI-Func |
Julian Date Conversion INBOUND |
| JULO-Func |
Julian Date Conversion OUTBOUND |
| READ-Func-Str |
Read String from File (1-Byte at
a time) |
| READ-Func-Chr |
Read Character from File
(1-Byte) |
| READ-Func-Pack |
Read Packed from File
(1-Byte/time) (COMP-3 support) |
| READ-Func-Num |
Read Numeric from File (1-Byte)
(COMP-3 support) |
| WRITE-Func-Str |
Write String to File (1-Byte at
a time) |
| WRITE-Func-Chr |
Write Character to File (1-Byte)
|
| WRITE-Func-Pack |
Write Packed to File (COMP-3
support) |
| WRITE-Func-Num |
Write Numeric to File (1-Byte)
(COMP-3 support) |
| PACK-Func-Set |
Set Packed (Transform Numeric to
COMP-3) |
| PACK-Func-Get |
Get Packed Byte (1-Byte at a
time) |
| PACK-Func-Write |
Write Packed Data (Entire COMP-3
Field) |
| UNPK-Func |
Unpack String Variable (from
Mainframe) |
| MFI-Func |
Mainframe Signed Number
Conversion INBOUND |
| MFO-Func |
Mainframe Signed Number
Conversion OUTBOUND |
| PARSE-Func-Put
|
Parse Delimited Record (Put
Fields into Array) |
| PARSE-Func-Get
|
Parse Delimited Record (Get
Field from Array) |
| IO-Func |
File INPUT/OUTPUT Prompts (and
Validation) |
| ORA-Func |
Parse ORACLE Error Code from SQL
Error String |
| PSNAME-Func |
PeopleSoft Name Validation
(Mimic Online Edit) |
| BIT-Func |
Simulate Bit Operations (XOR,
AND and OR) |
| BOOL-Func |
Numeric Boolean Operations (XOR,
AND and OR) |
| BASE-Func |
Convert Numeric TO/FROM Base
System String |
| INI-Func-New |
INI Matrix Init - For INI
Functions |
| INI-Func-Imp |
INI File Import - Load/Parse INI
into Array |
| INI-Func-Exp |
INI File Import - Build/Write
INI from Array |
| INI-Func-Put |
INI File Insert - Place Entry
into Array |
| INI-Func-Idx |
INI File Lookup - Sequential
Entry Retrieval |
| INI-Func-Get |
INI File Lookup - Direct Key
Entry Retrieval |
| INI-Func-Reg |
INI File Process - Windows
Registry Access |
