Wiki Home

St Denis


Namespace: WIN_COM_API
St_Denis library include the following UDFs FoxPro:
Working with words

GETALLWORDS() - Inserts the words from a string into a global dimensioned array.
WORDTRAN() - Searches a character string for occurrences of a first word, and then replaces each occurrence with a second word.
GETNUMWORD() - Returns the index position of a word in a string.
GETOCCURSWORD() - Returns the number of times a word occurs within the character string.
GETATWORD() - Returns the beginning numeric position of the nth occurrence of a word within the character string, counting from the leftmost character.
GETRATWORD() - Returns the numeric position of the last (rightmost) occurrence of a word within the character string.
Working with arrays
STRTRANEX() - A function with enhanced search-and-replace capabilities as compared to the built-in function STRTRAN().
WORDTRANEX() - A function with enhanced search-and-replace capabilities as compared to the function WORDTRAN().

Working with arrays

ARRAYSUM() - Returns the sum of all or a specified range of numeric (and/or currency) elements in the selected column of an array.
ARRAYAVG() - Computes the arithmetic average of all or a specified range of numeric (and/or currency) elements in the selected column of an array.
ARRAYMIN() - Evaluates all or a specified range of elements in the selected column of an array and returns the element and optional number of row with the minimum value.
ARRAYMAX() - Evaluates all or a specified range of elements in the selected column of an array and returns the element and optional number of row with the maximum value.
ARRAYCNT() - Counts the number of all or a specified range of numeric (and/or currency) elements in the selected column of an array.
ASCANQUICK() - Unlike the built-in function ASCAN(), performs a binary search in the selected column of a sorted array for an element containing the same data and data type as an expression.
VITESCAN() - Performs a binary search in the selected column of a sorted array for an element containing the same data and data type as an expression. This function is more simple than ASCANQUICK().

Other functions

FIELDNUM() - Returns the field number, referenced by name of a field, in a table.
DANSLISTE() - Determines whether a numeric expression is contained in the list of values of type 1,5,13-18
INCREMENT() - Increments or decrements the value of a variable passed by reference by one and returns the result
STRFILTER() - Removes all characters from a string except those specified.
REVERSE() - Returns the reverse of a character expression.
IFOR() - Immediate FOR cycle.
IWHILE() - Immediate WHILE cycle.
ICASE() - Evaluates the results from a list of conditions.
IEXECCASE() - Evaluates the results and executes the commands from a list of conditions.
IEXECIF() - Executes one of two string expressions, depending on the value of a logical expression, and returns the result.
EXECUTE() - Execute commands from a string and returns the result. Unlike a macro substitution, can execute several commands from one string.

Converting to/from Roman numerals

ARABTOROMAN() - Returns the character Roman numeral equivalent of a specified numeric expression (from 1 to 3999).
ROMANTOARAB() - Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX).

Plus, there are CHM files in English, French and German.

The ST_DENIS library is available for all versions Visual FoxPro through 9.0, FoxPro 2.6 for Windows and for FoxPro 2.6 for DOS. The VFP library is ST_DENIS.FLL and the FoxPro for DOS library is ST_DENIS.PLB. To register the library in your programs, use one of the SET LIBRARY commands:

SET LIBRARY TO ST_DENIS.FLL ADDITIVE && for VFP
or

SET LIBRARY TO ST_DENIS.PLB ADDITIVE && for FoxPro for DOS
It is best to place the library file in your search path (SET PATH command). If it is not in your search path, you will need to specify the path to the library file in the SET LIBRARY command:

SET LIBRARY TO ST_DENIS.FLL ADDITIVE
To remove the library from memory, use:

RELEASE LIBRAY ST_DENIS
or, if the library is not in the search path,

RELEASE LIBRARY ST_DENIS
Here is the list of files from the archive.

Here is the list of files from the archive.
01) St_Denis.fll library for VFP 9.0
02) St_Denis.fll library for VFP 8.0 and below
03) St_Denis.fll library for FoxPro 2.6 for Windows
04) St_Denis.plb library for FoxPro 2.6 for DOS
05) St_Denis.c source code
06) St_Denis.prg Implementation of some functions of library on FoxPro.
07) test_perf.prg test of performance.
08) mkeywords.prg makes table of keywords from memo field.
09) a form examstrtranex.scx, the form demonstrates the STRTRANEX() and WORDTRANEX() functions.
10) St_Denis_English.chm English documentation
11) St_Denis_French.chm French documentation
12) St_Denis_German.chm German documentation


There is a library with source code available.
Download

There is a library for Visual Studio.Net with source code (VB.Net, C#.Net, C++.Net) available.
Download

Igor Nikiforov is an author of those libraries.
( Topic last updated: 2009.11.27 12:16:46 PM )