Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Downloads
Add
Search: 
Search

User-Defined string functions Oracle PL/SQL
Igor Nikiforov, Belron Canada inc.
User-Defined string functions Oracle PL/SQL GETALLWORDS, GETWORDCOUNT, GETWORDNUM, OCCURS, PADC, STRTRAN, STRFILTER, ATC, RAT, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing of stored procedures and User-Defined Functions on Oracle Procedural Language SQL. Plus, there are CHM files in English, French, Spanish, German and Russian.
Created on
18 years ago
Downloads
3436
File type
Freeware
General information
URL:
UDFs_Oracle_PL_SQL.zip
Rating:
Rate this item
Description
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 ROMANTOARAB occurrence 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 create DB2 Sybase ASA MS SQL Server Visual Extend Framework VFX dFPUG ----------------------------------------------------------------------------------- User-Defined string functions Oracle PL/SQL : GETALLWORDS, GETWORDCOUNT, GETWORDNUM, OCCURS, PADC, STRTRAN, STRFILTER, RAT, ROMANTOARAB. In my humble opinion, it will be convenient to apply such functions for writing of stored procedures and User-Defined Functions on Oracle PL/SQL. ----------------------------------------------------------------------------------- To create those type of functions, open the iSQL*Plus, open the file create_udfs_functions.sql, and execute it. To delete the given function, open the iSQL*Plus, open the file drop_udfs_functions.sql, and execute it. ----------------------------------------------------------------------------------- I am pleased to offer, free of charge, the following string functions Oracle PL/SQL : GETALLWORDS(): Inserts the words from a string into the table. GETWORDCOUNT(): Counts the words in a string. GETWORDNUM(): Returns a specified word from a 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). OCCURS2 is faster than OCCURS. PADC(): Returns a string from an expression, padded with spaces or characters to a specified length on the both sides. 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. STRFILTER(): Removes all characters from a string except those specified. RAT(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string (including overlaps). The search performed by RAT() is case-sensitive. This is a trivial function for FoxPro developers. ATC(): Returns the beginning numeric position of the first occurrence of a character expression within another character expression, counting from the leftmost character (including overlaps). The search performed by ATC() is case-insensitive. ATC similar to the Oracle function INSTR. This is a trivial function for FoxPro developers. RATC(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string (including overlaps). The search performed by RATC() is case-insensitive. This is a trivial function for FoxPro developers. AT2(): Returns the beginning numeric position of the first occurrence of a character expression within another character expression, counting from the leftmost character (excluding overlaps). The search performed by AT2() is case-sensitive. AT2 similar to the Oracle function INSTR. ROMANTOARAB(): Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX). ----------------------------------------------------------------------------------- Je voudrais bien vous proposer gratuitement les fonctions en Oracle PL/SQL qui sont les suivantes GETALLWORDS(): Insère tous les mots d'une chaîne dans la table. GETWORDCOUNT(): Renvoie le nombre de mots à l'intérieur d'une chaîne. GETWORDNUM(): Renvoie un mot spécifié d'une chaîne. OCCURS(): Renvoie le nombre d'occurrences d'une expression caractère à l'intérieur d'une autre expression caractère (y compris les chevauchements éventuels). OCCURS2():Renvoie le nombre d'occurrences d'une expression caractère à l'intérieur d'une autre expression caractère (en excluant les chevauchements éventuels). PADC(): Renvoie une chaîne de caractères à la longueur spécifiée à partir d'une expression complétée des deux côtés par des espaces ou des caractères. STRTRAN(): Recherche dans une expression caractère des occurrences d'une deuxième expression caractère, puis remplace chaque occurrence par une troisième expression caractère. À la différence d'une fonction intégrée Replace, STRTRAN a trois paramètres supplémentaires. STRFILTER(): Enlève tous les caractères d'une chaîne sauf ceux qui sont spécifiés. RAT(): Renvoie la position numérique de la dernière occurrence (extrême droite) d'une chaîne de caractères au sein d'une autre chaîne de caractères. ROMANTOARAB(): Renvoie une expression numérique équivalente à un nombre romain spécifié. Pour plus d'information en langue française, veuillez visiter: http://nikiforov.developpez.com/ ----------------------------------------------------------------------------------- Quisiera poner a su alcance en forma gratuita las siguientes funciones de Oracle PL/SQL : GETALLWORDS(): Inserta las palabras de una cadena en la tabla. GETWORDCOUNT(): Cuenta el número de palabras de una cadena. GETWORDNUM(): Devuelve la palabra especificada de una cadena. OCCURS(): Devuelve el número de veces que ocurre una expresión dentro de otra expresión de carácteres (incluye solapamientos). OCCURS2(): Devuelve el número de veces que ocurre una expresión dentro de otra expresión de carácteres (excluye solapamientos). PADC(): Devuelve una cadena a partir de una expresión, rellenándola por ambos lados hasta la longitud especificada. STRTRAN(): Busca en una expresión de caracteres las apariciones de una segunda expresión de caracteres, y luego reemplaza cada aparición con una tercera expresión de caracteres (a distinción de la función incorporada replace, STRTRAN tiene tres parámetros adicionales). STRFILTER(): Quita todos los carácteres de una cadena de carácteres excepto aquellos especificados. RAT(): Devuelve la posición numérica de la enésima aparición (más a la derecha) de una cadena de carácteres dentro de otra cadena de carácteres. ROMANTOARAB(): Devuelve la expresión numérica equivalente de un número romano especificado. Para obtener más información, por favor visite: http://nikiforov.developpez.com/espagnol/ ----------------------------------------------------------------------------------- For information about string UDFs in Portuguese language please visit the http://nikiforov.developpez.com/portugais/ ----------------------------------------------------------------------------------- For information about string UDFs in German language please visit the http://nikiforov.developpez.com/allemand/ ----------------------------------------------------------------------------------- For information about string UDFs in Italian language please visit the http://nikiforov.developpez.com/italien/ ----------------------------------------------------------------------------------- For information about string UDFs in Romanian language please visit the http://nikiforov.developpez.com/roumain/ ----------------------------------------------------------------------------------- For information about string UDFs in Russian language please visit the http://nikiforov.developpez.com/russe/ ----------------------------------------------------------------------------------- For information about string UDFs in Bulgarian language please visit the http://nikiforov.developpez.com/bulgare/ ----------------------------------------------------------------------------------- GETALLWORDS() User-Defined Function Inserts the words from a string into the table. GETALLWORDS( cString[, cDelimiters]) Return Value table GETALLWORDS (WORDNUM smallint, WORD nvarchar2(4000), STARTOFWORD smallint, LENGTHOFWORD smallint) Parameters cString nvarchar2 - Specifies the string whose words will be inserted into the table GETALLWORDS. cDelimiters nvarchar2(256) - Optional. Specifies one or more optional characters used to separate words in cString. The default delimiters are space, tab, carriage return, and line feed. Note that GETALLWORDS( ) uses each of the characters in cDelimiters as individual delimiters, not the entire string as a single delimiter. Remarks GETALLWORDS() by default assumes that words are delimited by spaces or tabs. If you specify another character as delimiter, this function ignores spaces and tabs and uses only the specified character. Example select * from table( GETALLWORDS('The default delimiters are space, tab, carriage return, and line feed. If you specify another character as delimiter, this function ignores spaces and tabs and uses only the specified character.')) ; See Also GETWORDNUM() , GETWORDCOUNT(), GETALLWORDS2() User-Defined Functions GETALLWORDS2() User-Defined Function Inserts the words from a string into the table. GETALLWORDS2( cString[, cStringSplitting]) Return Value table GETALLWORDS (WORDNUM smallint, WORD nvarchar2(4000), STARTOFWORD smallint, LENGTHOFWORD smallint) Parameters cString nvarchar2 - Specifies the string whose words will be inserted into the temporary table GETALLWORDS. cStringSplitting nvarchar2(256) - Optional. Specifies the string used to separate words in cString. The default delimiter is space. Note that GETALLWORDS2( ) uses the entire string cStringSplitting as a single delimiter. Remarks GETALLWORDS2() by default assumes that words are delimited by space. If you specify another string as a single delimiter, this function ignores space and uses only the specified string as a single delimiter. Example select WORD from table( GETALLWORDS2('We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain unalienable Rights, that among these are Life, Liberty and the pursuit of Happiness.')) where WORDNUM = 30 ; -- Displays 'Liberty' select WORDNUM from (select WORDNUM, row_number() over (order by WORDNUM desc) R from table( GETALLWORDS2('Oracle PL/SQL '))) where R = 1; -- Displays 2 See Also GETWORDNUM() , GETWORDCOUNT(), GETALLWORDS() User-Defined Functions GETWORDCOUNT() User-Defined Function Counts the words in a string. GETWORDCOUNT( cString[, cDelimiters]) Return Value smallint Parameters cString nvarchar2 - Specifies the string whose words will be counted. cDelimiters nvarchar2(256) - Optional. Specifies one or more optional characters used to separate words in cString. The default delimiters are space, tab, carriage return, and line feed. Note that GETWORDCOUNT( ) uses each of the characters in cDelimiters as individual delimiters, not the entire string as a single delimiter. Remarks GETWORDCOUNT() by default assumes that words are delimited by spaces or tabs. If you specify another character as delimiter, this function ignores spaces and tabs and uses only the specified character. Example select GETWORDCOUNT('To be, or not to be: that is the question:') from sys.dual; -- Displays 10 See Also GETWORDNUM(), GETALLWORDS(), GETALLWORDS2() User-Defined Functions GETWORDNUM() User-Defined Function Returns a specified word from a string. GETWORDNUM( cString, nIndex[, cDelimiters]) Return Value nvarchar2 Parameters cString nvarchar2 - Specifies the string to be evaluated nIndex smallint - Specifies the index position of the word to be returned. For example, if nIndex is 3, GETWORDNUM( ) returns the third word (if cString contains three or more words). cDelimiters nvarchar2(256) - Optional. Specifies one or more optional characters used to separate words in cString. The default delimiters are space, tab, carriage return, and line feed. Note that GetWordNum( ) uses each of the characters in cDelimiters as individual delimiters, not the entire string as a single delimiter. Remarks Returns the word at the position specified by nIndex in the target string, cString. If cString contains fewer than nIndex words, GETWORDNUM( ) returns an empty string. Example select GETWORDNUM('Whether ''tis nobler in the mind to suffer', 3 ) from sys.dual; -- Displays 'nobler' See Also GETWORDCOUNT(), GETALLWORDS(), GETALLWORDS2() User-Defined Functions The accuracy criteria of user-defined functions GETWORDNUM() , GETWORDCOUNT(), GETALLWORDS(), GETALLWORDS2() working with strings: 1) Both character parameters are empty - the function returns nothing - either 0 strings, or 0. 2) The first parameter is not empty, the second is empty - the function returns the table from one string or 1. The first parameter is in this case the required word. 3) The function works correctly with strings starting and/or finishing with one or several delimiters. 4) The function works correctly on strings consisting only of delimiters - a result in this case is 0 strings, or 0 words. 5) The function works correctly irrespective of the character sets in the string or delimiters, including /, \,?, ^, %, -, ' etc., that is, any character that have special function. No exceptions, if the parameters of an incorrect type are transmitted, there is a standard error message. Above mentioned and other functions completely correspond to these criteria. OCCURS() User-Defined Function Returns the number of times a character expression occurs within another character expression (including overlaps). OCCURS( cSearchExpression, cExpressionSearched) Return Values smallint Parameters cSearchExpression nvarchar2 Specifies a character expression that OCCURS() searches for within cExpressionSearched. cExpressionSearched nvarchar2 Specifies the character expression OCCURS() searches for cSearchExpression. Remarks OCCURS() returns 0 (zero) if cSearchExpression is not found within cExpressionSearched. Example select OCCURS('a', 'abracadabra') from sys.dual; -- Displays 5 Attention, including overlaps !!! select OCCURS('ABCA', 'ABCABCABCA') from sys.dual; -- Displays 3 1 occurrence of substring 'ABCA .. BCABCA' 2 occurrence of substring 'ABC...ABCA...BCA' 3 occurrence of substring 'ABCABC...ABCA' See Also ATC(), RAT(), OCCURS2() OCCURS2() User-Defined Function When performance is an issue: use nvl((length(cExpressionSearched) - nvl(length(replace(cExpressionSearched, cSearchExpression, '')),0)) / length(cSearchExpression),0) rather than this function. Returns the number of times a character expression occurs within another character expression (excluding overlaps). OCCURS2( cSearchExpression, cExpressionSearched) Return Values smallint Parameters cSearchExpression nvarchar2 Specifies a character expression that OCCURS2() searches for within cExpressionSearched. cExpressionSearched nvarchar2 Specifies the character expression OCCURS2() searches for cSearchExpression. Remarks OCCURS2() returns 0 (zero) if cSearchExpression is not found within cExpressionSearched. Example select OCCURS2('a', 'abracadabra') from sys.dual; -- Displays 5 Attention !!! This function counts the 'occurs' excluding overlaps ! select OCCURS2('ABCA', 'ABCABCABCA') from sys.dual; -- Displays 2 1 occurrence of substring 'ABCA .. BCABCA' 2 occurrence of substring 'ABCABC... ABCA' See Also OCCURS() PADC() User-Defined Function Returns a string from an expression, padded with spaces or characters to a specified length on the both sides. PADC( eExpression, nResultSize [, cPadCharacter]) Return Values nvarchar2 Parameters eExpression nvarchar2 Specifies the expression to be padded. nResultSize smallint Specifies the total number of characters in the expression after it is padded. cPadCharacter nvarchar2 Specifies the value to use for padding. This value is repeated as necessary to pad the expression to the specified number of characters. If you omit cPadCharacter, spaces (ASCII character 32) are used for padding. Example select PADC(' TITLE', 40, '=*=') from sys.dual; -- Displays '=*==*==*==*==*==*TITLE=*==*==*==*==*==*=' STRTRAN() User-Defined Function Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. STRTRAN ( cSearched, cExpressionSought , [ cReplacement][, nStartOccurrence] [, nNumberOfOccurrences] [, nFlags]) Return Values nvarchar2 Parameters cSearched nvarchar2 Specifies the character expression that is searched. cExpressionSought nvarchar2 Specifies the character expression that is searched for in cSearched. cReplacement nvarchar2 Specifies the character expression that replaces every occurrence of cExpressionSought in cSearched. If you omit cReplacement, every occurrence of cExpressionSought is replaced with the empty string. nStartOccurrence smallint Specifies which occurrence of cExpressionSought is the first to be replaced. For example, if nStartOccurrence is 4, replacement begins with the fourth occurrence of cExpressionSought in cSearched and the first three occurrences of cExpressionSought remain unchanged. The occurrence where replacement begins defaults to the first occurrence of cExpressionSought if you omit nStartOccurrence. nNumberOfOccurrences smallint Specifies the number of occurrences of cExpressionSought to replace. If you omit nNumberOfOccurrences, all occurrences of cExpressionSought, starting with the occurrence specified with nStartOccurrence, are replaced. nFlags smallint Specifies the case-sensitivity of a search according to the following values: ----------------------------------------------------------------------------------------- nFlags Description 0 (default) Search is case-sensitive, replace is with exact cReplacement string. 1 Search is case-insensitive, replace is with exact cReplacement string. 2 Search is case-sensitive; replace is with the case of cReplacement changed to match the case of the string found. The case of cReplacement will only be changed if the string found is all uppercase, lowercase, or proper case. 3 Search is case-insensitive; replace is with the case of cReplacement changed to match the case of the string found. The case of cReplacement will only be changed if the string found is all uppercase, lowercase, or proper case. ----------------------------------------------------------------------------------------- Remarks You can specify where the replacement begins and how many replacements are made. STRTRAN( ) returns the resulting character string. Specify –1 for optional parameters you want to skip over if you just need to specify the nFlags setting. Example select STRTRAN('ABCDEF', 'ABC', 'XYZ',-1,-1,0) from sys.dual; -- Displays XYZDEF select STRTRAN('ABCDEF', 'ABC', '',-1,-1,0) from sys.dual; -- Displays DEF select STRTRAN('ABCDEFABCGHJabcQWE', 'ABC', '',2,-1,0) from sys.dual; -- Displays ABCDEFGHJabcQWE select STRTRAN('ABCDEFABCGHJabcQWE', 'ABC', '',2,-1,1) from sys.dual; -- Displays ABCDEFGHJQWE select STRTRAN('ABCDEFABCGHJabcQWE', 'ABC', 'XYZ', 2, 1, 1) from sys.dual; -- Displays ABCDEFXYZGHJabcQWE select STRTRAN('ABCDEFABCGHJabcQWE', 'ABC', 'XYZ', 2, 3, 1) from sys.dual; -- Displays ABCDEFXYZGHJXYZQWE select STRTRAN('ABCDEFABCGHJabcQWE', 'ABC', 'XYZ', 2, 1, 2) from sys.dual; -- Displays ABCDEFXYZGHJabcQWE select STRTRAN('ABCDEFABCGHJabcQWE', 'ABC', 'XYZ', 2, 3, 2) from sys.dual; -- Displays ABCDEFXYZGHJabcQWE select STRTRAN('ABCDEFABCGHJabcQWE', 'ABC', 'xyZ', 2, 1, 2) from sys.dual; -- Displays ABCDEFXYZGHJabcQWE select STRTRAN('ABCDEFABCGHJabcQWE', 'ABC', 'xYz', 2, 3, 2) from sys.dual; -- Displays ABCDEFXYZGHJabcQWE select STRTRAN('ABCDEFAbcCGHJAbcQWE', 'Aab', 'xyZ', 2, 1, 2) from sys.dual; -- Displays ABCDEFAbcCGHJAbcQWE select STRTRAN('abcDEFabcGHJabcQWE', 'abc', 'xYz', 2, 3, 2) from sys.dual; -- Displays abcDEFxyzGHJxyzQWE select STRTRAN('ABCDEFAbcCGHJAbcQWE', 'Aab', 'xyZ', 2, 1, 3) from sys.dual; -- Displays ABCDEFAbcCGHJAbcQWE select STRTRAN('ABCDEFAbcGHJabcQWE', 'abc', 'xYz', 1, 3, 3) from sys.dual; -- Displays XYZDEFXyzGHJxyzQWE See Also replace() STRFILTER() User-Defined Function When performance is an issue: use translate(cExpressionSearched, cSearchExpression || cExpressionSearched, cSearchExpression) rather than this function. Removes all characters from a string except those specified. STRFILTER( cExpressionSearched, cSearchExpression) Return Values nvarchar2 Parameters cExpressionSearched Specifies the character string to search. cSearchExpression Specifies the characters to search for and retain in cExpressionSearched. Remarks STRFILTER( ) removes all the characters from cExpressionSearched that are not in cSearchExpression, then returns the characters that remain. Example select STRFILTER('asdfghh5hh1jk6f3b7mn8m3m0m6','0123456789') from sys.dual; -- Displays 516378306 select STRFILTER('ABCDABCDABCD', 'AB') from sys.dual; -- Displays ABABAB See Also STRTRAN() User-Defined Function ATC() User-Defined Function When performance is an issue: use nvl(instr(lower(cExpressionSearched), lower(cSearchExpression), 1, nOccurrence),0) rather than this function. Returns the beginning numeric position of the first occurrence of a character expression within another character expression, counting from the leftmost character (including overlaps). ATC similar to the Oracle function INSTR (but the search performed by INSTR is case-sensitive) ATC( cSearchExpression, cExpressionSearched [, nOccurrence]) Return Values smallint Parameters cSearchExpression nvarchar2 Specifies the character expression that ATC() searches for in cExpressionSearched. cExpressionSearched nvarchar2 Specifies the character expression cSearchExpression searches for. nOccurrence smallint Specifies which occurrence (first, second, third, and so on) of cSearchExpression is searched for in cExpressionSearched. By default, ATC() searches for the first occurrence of cSearchExpression ( nOccurrence = 1). Including nOccurrence lets you search for additional occurrences of cSearchExpression in cExpressionSearched. ATC() returns 0 if nOccurrence is greater than the number of times cSearchExpression occurs in cExpressionSearched. Remarks ATC() searches the second character expression for the first occurrence of the first character expression. It then returns an integer indicating the position of the first character in the character expression found. If the character expression isn't found, ATC() returns 0. The search performed by ATC() is case-INsensitive. Example select ATC('IS THE', 'Now is the time for all good men', 1) from sys.dual; -- Displays 5 See Also RAT(), AT2(), RATC() User-Defined Functions RAT( ) User-Defined Function When performance is an issue: use nvl(instr(cExpressionSearched, cSearchExpression, -1, nOccurrence),0) rather than this function. Returns the numeric position of the last (rightmost) occurrence of a character string within another character string (including overlaps). RAT( cSearchExpression, cExpressionSearched [, nOccurrence]) RAT similar to the Oracle function INSTR Return Values smallint Parameters cSearchExpression varchar2(4000) Specifies the character expression that RAT( ) looks for in cExpressionSearched. cExpressionSearched varchar2(4000) Specifies the character expression that RAT() searches. nOccurrence smallint Specifies which occurrence, starting from the right and moving left, of cSearchExpression RAT() searches for in cExpressionSearched. By default, RAT() searches for the last occurrence of cSearchExpression ( nOccurrence = 1). If nOccurrence is 2, RAT() searches for the next to last occurrence, and so on. Remarks RAT(), the reverse of the AT() function, searches the character expression in cExpressionSearched starting from the right and moving left, looking for the last occurrence of the string specified in cSearchExpression. RAT() returns an integer indicating the position of the first character in cSearchExpression in cExpressionSearched. RAT() returns 0 if cSearchExpression isn't found in cExpressionSearched, or if nOccurrence is greater than the number of times cSearchExpression occurs in cExpressionSearched. The search performed by RAT() is case-sensitive. Example select RAT('a', 'abracadabra', 3) from sys.dual; -- Displays 6 See Also ATC(), RATC() User-Defined Function ROMANTOARAB() Returns the number equivalent of a specified character Roman numeral expression ROMANTOARAB( tcRomanNumber) Return Values smallint Parameters tcRomanNumber varchar2(15) Roman number Example select ROMANTOARAB('MDCCCLXXXVIII') from sys.dual; -- Displays 1888 to_char(tNum,'RN') Returns the character Roman numeral equivalent of a specified numeric expression select to_char(3888,'RN') from sys.dual; -- Displays MMMDCCCLXXXVIII ----------------------------------------------------------------------------------- User-Defined Functions Oracle PL/SQL , the name and functionality of which correspond to the same built-in functions of Visual FoxPro ----------------------------------------------------------------------------------- Testimonials: 1) ‘I googled for some text-functions which are not included in oracle's sql or pl/sql. And I found your UDFs, which cover more than I was searching for ;-) I need "count the words in a string" and "extract n-th word with delimiter ';'" Thank you for sharing your knowledge.' Frank, Berlin, Germany ___________________________________________ I express my gratitude to the following donors for appreciating my work and for their monetary contribution: (I will place a link to a donor's website if requested.) 1. Mr. James Woodin, Iowa, USA
Created by
Igor Nikiforov, Belron Canada inc.

Comments
Add a comment
More downloads created from this member
St_Denis library of User-defined string functions Visual Studio.Net
Igor Nikiforov, Belron Canada inc.
The St_Denis library is available for VB.Net, C#.Net and C++.Net . In total the library has about 30 functions. In my humble opinion, it will be convenient to apply such functions for developing applications.
Created on
14 years ago
Downloads
1127
File type
Freeware
AGETFILESUMMARY is the same thing as AGETFILEVERSION but for Summary resources.
Igor Nikiforov, Belron Canada inc.
AGETFILESUMMARY is the same thing as AGETFILEVERSION but for Summary resources. the code from http://support.microsoft.com/kb/186898/en-us has been adapted for VFP fll library by Igor Nikiforov 2008-11-12 Creates an array containing information about files with summary resources or about Compo...
Created on
15 years ago
Downloads
913
File type
Freeware
User-Defined string functions Visual Basic
Igor Nikiforov, Belron Canada inc.
User-Defined string functions Visual Basic STRTRANEX, WORDTRANEX, AT, RAT, OCCURS, PADC, PADR, PADL, CHRTRAN, STRFILTER, STRTRAN, WORDTRAN, GETWORDCOUNT, GETWORDNUM, GETNUMWORD, GETALLWORDS, ARABTOROMAN, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writin...
Created on
16 years ago
Downloads
1602
File type
Freeware
St_Denis library of User-defined functions LCK VFP
Igor Nikiforov, Belron Canada inc.
The ST_DENIS library is available for all versions Visual FoxPro through 9.0, FoxPro 2.6 for DOS and FoxPro 2.6 for Windows. In total the library has about 25 functions. In my humble opinion, it will be convenient to apply such functions for developing applications. Here is the list of functions ...
Created on
17 years ago
Downloads
3826
File type
Freeware
UDFs T-SQL CLR (VB. Net, C#.Net, C++. Net)
Igor Nikiforov, Belron Canada inc.
User-Defined string functions Transact-SQL MS SQL Server 2005, 2008 Common Language Runtime CLR (VB. Net, C#.Net, C++. Net) with source code. AT RAT OCCURS PADC PADR PADL CHRTRAN STRFILTER STRTRAN WORDTRAN GETWORDCOUNT GETWORDNUM GETNUMWORD GETALLWORDS GETOCCURSWORD GETATWORD GETRATWORD PROPER RC...
Created on
18 years ago
Downloads
6475
File type
Freeware
User-Defined string functions SQL PL DB2
Igor Nikiforov, Belron Canada inc.
User-Defined string functions SQL Procedural Language DB2 AT, RAT, OCCURS, PADC, PADR, PADL, CHRTRAN, STRTRAN, STRFILTER, GETWORDCOUNT, GETWORDNUM, GETALLWORDS, PROPER, RCHARINDEX, ARABTOROMAN, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing of st...
Created on
18 years ago
Downloads
2556
File type
Freeware
User-Defined string functions Transact-SQL Sybase
Igor Nikiforov, Belron Canada inc.
User-Defined string functions Transact-SQL Sybase ASA AT, RAT, OCCURS, PADC, PADR, PADL, CHRTRAN, STRTRAN, STRFILTER, GETWORDCOUNT, GETWORDNUM, GETALLWORDS, PROPER, RCHARINDEX, ARABTOROMAN, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing of stored p...
Created on
18 years ago
Downloads
2798
File type
Freeware
User-Defined string functions Transact-SQL
Igor Nikiforov, Belron Canada inc.
User-Defined string functions Transact-SQL AT, RAT, OCCURS, PADC, PADR, PADL, CHRTRAN, STRFILTER, STRTRAN, WORDTRAN, GETWORDCOUNT, GETWORDNUM, GETNUMWORD, GETALLWORDS, PROPER, RCHARINDEX, ARABTOROMAN, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing ...
Created on
19 years ago
Downloads
17535
File type
Freeware
Rating
5.00/5.00