User-Defined functions (UDFs)

My Photo
Name:
Location: Montréal, Québec, Canada

My height is 181 centimeters, my weight is 76 kilograms. I am an author of User-defined string functions. Each day my functions are downloaded on average by 30 people from around the world, but mostly from North and Latin America, and Europe. More than 30 000 people have already downloaded my functions. Please try a Google Search for keywords such as "Transact-SQL PROPER" or "Transact-SQL GETWORDCOUNT". My functions include versions for MS SQL Server (7.0, 2000, and 2005), MS SQL Server 2005 CLR .Net, Sybase ASA, DB2 and Oracle. I would like to bring to your attention that I found errors in the MS SQL Server, Sybase and DB2, which attests to the quality of my work.

Monday, January 01, 2007

Help in translation (English and other languages)

Hello all,

I need English native speakers’ help to correct the English text of my description of User-defined functions LCK Visual FoxPro and the several comments in the C++ and VFP source code.They will be disseminated as a free of charge download.In order to get an idea how many texts are already translated and corrected, and also to get a working version of the library, please download the file
ftp://ftp-developpez.com/nikiforov/udfs/st_denis.zip
The description of each function is similar to the description of functions in the help VFP. The shortest description consists of several lines, the longest is similar to a description of a ASCAN() function. In total the library has about 20 functions, but the descriptions of some of them are practically identical, as is the case, for example, for search functions of minimum / maximum values among elements of an array column.
Therefore, a help of about 10 people is needed, each one doing only a fraction of the total required work.If you would like to help me, please send an email to udfunctions@gmail.com (Subject: Help in translation). I will send you a function description or a line of the comment in source code, together with the library and an example of usage.The names of people who will assist in correcting the text will be published on my page or in the CHM description files, unless requested otherwise.
I am planning to produce a complete description of my functions in French, German, Spanish and Romanian. If you are proficient in one of those languages, please write to me at udfunctions@gmail.com (Subject: Help in French translation or Help in Spanish translation etc)
I am also planning to translate the list of functions into other European languages, as well as into Turkish, Arabic, Hebrew, Chinese, Japanese and Korean.A help of two people would be very appreciated in that regard.
Thank you very much for offering your help.
Sincerely,Igor Nikiforov

P.S.Here is the list of functions from the library.
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() - Returns one of two values and executes one of two string of the commands depending on the value of a logical expression.
EXECUTE() - Execute the commands from a string, unlike a macro substitution can execute the several commands from one string and returns the result.
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 resultWorking with arraysA
RRAYSUM() - 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().
GETALLWORDS() - Inserts the words from a string into a global dimensioned array.

Saturday, August 19, 2006

Help in translation

Hello all,

1)
I need English native speakers’ help to correct the English text of my description of User-defined functions LCK Visual FoxPro and the several comments in the C++ and VFP source code. They will be disseminated as a free of charge download.The description of each function is similar to the description of functions in the help VFP. The shortest description consists of several lines, the longest is similar to a description of a ASCAN() function. In total the library has about 20 functions, but the descriptions of some of them are practically identical, as is the case, for example, for search functions of minimum / maximum values among elements of an array column. Therefore, a help of about 10 -15 people is needed, each one doing only a fraction of the total required work.
If you would like to help me, please send an email to udfunctions(a)gmail.com (Subject: Help in translation). I will send you a function description or a line of the comment in source code, together with the library and an example of usage.The names of people who will assist in correcting the text will be published on my page or in the CHM description files, unless requested otherwise.Thank you very much for offering your help.
2)
Five people have responded to my request to help with the correction of the English text.Although half of all the work has been already done, I still need 5-7 voluntaires to help to complete the work.I am very grateful to those who have responded.Yet, I am once again humbly repeating my request for help.If you can spend a maximum of 40 minutes of time in order to correct a broken English text of the type:
[The sample of the text]
If the remainder from the quantity of passed parameters divided into three is one, penultimate, and accordingly,if the mentioned remainder is two, the last parameter cOtherwiseExecutedExpressions is considered as a string of the executed commands separated by the “;” character, in case of if all logical conditions are false.If the remainder from the quantity of passed parameters divided into three is two, the last parameter is considered as returned result cOtherwiseResult, in case of if all logical conditions are false.
[End the sample of the text]

Here is the list of functions from the library.
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() - Returns one of two values and executes one of two string of the commands depending on the value of a logical expression.
EXECUTE() - Execute the commands from a string, unlike a macro substitution can execute the several commands from one string and returns the result.
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 resultWorking with arrays
ARRAYSUM() - Totals all or specified numeric elements in the selected column of an array.
ARRAYAVG() - Computes the arithmetic average of all or specified numeric elements in the selected column of an array.
ARRAYMIN() - Evaluates all or specified 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 specified elements in the selected column of an array and returns the element and optional number of row with the maximum value.
ARRAYCNT() - Counts all or specified numeric elements in the selected column of the 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().
GETALLWORDS() Inserts the words from a string or memo field into the global array.

I am planning to produce a complete description of my functions in French, German, Spanish and Romanian.If you are proficient in one of those languages, please write to me at udfunctions(a)gmail.com (Subject: Help in French translation or Help in Spanish translation etc)

I am also planning to translate the list of functions into other European languages,as well as into Arabic, Hebrew, Chinese, Japanese and Korean. A help of one or two people would be very appreciated in that regard.
One people have responded to my request to help with the correction of the Portuguese text.
Each assistant will be very valuable.

Sunday, June 11, 2006

User-Defined string Functions MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net)

Ladies and Gentlemen,

I am pleased to offer, free of charge, the following string functions MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net):

AT(): Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character.
RAT(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string.
OCCURS(): Returns the number of times a character expression occurs within another character expression (including overlaps).
OCCURS2(): Returns the number of times a character expression occurs within another character expression (excluding overlaps).
PADL(): Returns a string from an expression, padded with spaces or characters to a specified length on the left side.
PADR(): Returns a string from an expression, padded with spaces or characters to a specified length on the right side.
PADC(): Returns a string from an expression, padded with spaces or characters to a specified length on the both sides.
CHRTRAN(): Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression. STRTRAN(): Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. Unlike a built-in function Replace, STRTRAN has three additional parameters to help refine searches.
STRFILTER(): Removes all characters from a string except those specified.
GETWORDCOUNT(): Counts the words in a string.
GETWORDNUM(): Returns a specified word from a string.
GETALLWORDS(): Inserts the words from a string into the table.
PROPER(): Returns from a character expression a string capitalized as appropriate for proper names.
RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right search.
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).

AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP.

Plus, there are CHM files in English, French, Spanish, German and Russian.
Plus, there are versions for MS SQL SERVER, SYBASE ASA, DB2, Oracle.

More than 10000 people have already downloaded my functions. I hope you will find them useful as well.

For more information about string UDFs MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net) please visit thehttp://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,29527

Please, download the file

With the best regards.

Keywords: Oracle PL/SQL User-Defined string functions SQL PL Procedural Language UDFs UDF function similar function Oracle PL/SQL INSTR LPAD RPAD TRANSLATE INITCAP REGEXP_SUBSTR REGEXP_INSTR REGEXP_LIKE REGEXP_REPLACE regular expressions VFP Visual FoxPro Fox RAT OCCURS PADC CPAD STRTRAN STRFILTER GETWORDCOUNT GETWORDNUM GETALLWORDS ROMANTOARABoccurrence appearance location whereabouts ubiety split cleave rend sever break up divide split up cut hack fracture pad padding expand enlarge amplify augment increase stuff word parol saying byword string sequence translation transformation conversion change alteration alter recast remodel make over search exploration examination inquiry scrutiny research renovation renewal rejuvenation capitalize capitalize letters capitalized slice chop example createDB2 Sybase ASA MS SQL Server Visual Extend Framework VFX dFPUG

Saturday, June 10, 2006

My photos




View My Stats