Results for "Category: String Manipulation"

This is a simple procedure to show how to use an XML file as datasource to build a datagrid in ASP. If you like it please vote. P/S: future updates will be available on http://www.aspwebsolution.com

Updated to v1.1, Fixed few bugs. I always feel I loose a lot of time formating my msgbox strings. String Maker is a program that formats your "normal text" into a variable string usable in visual basic. Lets say, for example, you want a msgbox to show this: ------------------------------------- Warning: The "input" parameters found in the data size field can generate a general protection error ------------------------------------- String maker will format it for you to just copy and paste like this: MyString = "-------------------------------------" & vbNewLine MyString = MyString & " Warning:" & vbNewLine MyString = MyString & "The " & chr(34) & "input" & chr(34) & "parameters" & vbNewLine MyString = MyString & "found in the data size" & vbNewLine MyString = MyString & "field can generate a" & vbNewLine MyString = MyString & "general protection error" & vbNewLine MyString = MyString & "-------------------------------------" Then you could use it like: MsgBox mystring It also has the capability to create SQL table strings: MyString = "CREATE TABLE [tblThisTable] (" MyString = MyString & "[fldBinary] Binary(20)," MyString = MyString & "[fldBit] BIT," MyString = MyString & "[fildInteger] Short," MyString = MyString & "[fldText] Text(240)" MyString = MyString & ")" All you have to do is execute the string like dbobject.execute mystring. And, as always, it also shows the use of MDI projects, menus, tray icon, popup menu in the tray icon, selections, etc... You are allowed and encouraged to continue this project to grow its capabilities... just keep me informed. Thanx to the guy of the tray area control. Note that you must use the exit menu command to close the program, since pressing the X button in the window's controls will just send the program to the tray area... Pretty much like audiogalaxy. -Fongus

This module contains a function that will take a currency var (up to 999,999,999.99) and return the result (including cents) as a string "spelled-written" amount formated for mexican pesos. 'Public Function ConvierteNumeroALetra(Numero As Currency) As String' Altrough it was made for mexican pesos, it can be easily adapted for any unit, in any language,in any way. There are lots of number2words functions out there, but I think mine is the more understandable ans simplier of 'em. You will have to spend some time converting the spanish numbers to english, thou... ---------------- Este modulo contiene una funcion que toma una variable de moneda(currency) (Hasta 999,999,999.99) y regresa la cantidad de forma escrita como String. (Incluye centavos) 'Public Function ConvierteNumeroALetra(Numero As Currency) As String' La cantidad escrita la regresa usando el formato de monto escrito en pesos mexicanos, usado en cheques, depositos, facturas, etc. Por ejemplo: $1,525.23 = (Mil Quinientos Veinticinco Pesos, 23/100 M.N.) Los centavos se escriben siempre sobre cien, y M.N. significa Moneda Nacional. Si esto les sirve, haganmelo saber. -Fongus

This function takes tag delimited text and converts it for display in a richtext box. Great for email headers (from, to, subject lines). Someone Rank this Thing...Enjoy!!

A template class that can write,read,modify & delete objects of any class/structure to a database.

Compact and Repair You can use the "Compact and Repair" function in Access from ASP code. The following code is an example of how this can be done. Note that when you decide to "Compact and Repair" your Access database, some autonumbers can be changed. Access makes all autonumbers consecutive. This code uses one database, but I'm sure the code can easily be changed so that the listbox displays, for example, all the databases in one folder.

This is a subroutine to automatically wrap a text string in whole words to a printer.

ever made a program capable of showing barcodes ? if you did than you`ve been there ,,, at the oficial EAN standards site,, than you would have seen how to calculate the check digit. they hold the standard they publish that standard also on their website ,,, http://www.ean-int.org/index800.html i never found code in VB that calculates the check digit ,, so my conclusion is that it was hold for comercial reassons ( there are lots of controls out there for a lot of monney :-) so i donate this M. Posseth code to the public and make it public domain ,,, uhmmm votes would be apreciated :-)

This modification of Lewis Moten's RC4 algorithm will allow you to send encrypted strings to DataSources through SQL.

Break up variables in a string, whatever separator is used.

The ODL Converter Project is designed to take VB Types, Enums and Declare Statements and convert them into a format used by Visual C++'s .odl files (odl = Object Description Language). This also shows how to colorize code, for those who are interested

I was just poking around this site, and noticed that a lot of folks were making the copy/paste/cut/undo functions more difficult then they really needs to be. Rather then writing your own functions, make use of the SendMessage API and let Windows do the work for you.

Finally a little example of Artificial Intelligence in VB. This code was not developed by me, but i just want to share with you. I perceived that does not exist any example that uses natural language in the PSC, and focus on artificial intelligence in AIML. Therefore they use to advantage to use the ALICE and the TED, the two robots gifts in this example. Gratefulness special to the Dr. Wallace.

Wouldn't it be nice if you could use good-ole SQL language to execute a Select statement against a set of locally-cached DataTables that you've already retrieved from an underlying database? This class does exactly that... it supports a minimal set of SQL SELECT command statements against a group of ADO.Net DataTables contained in a detached DataSet. The purpose is to prevent a round trip to the server to accomplish simple things like what is available with the JOIN and GROUP BY clauses of the SELECT command. The syntax for the SELECT command is designed around the SQL Server 2000 dialect of the SQL language. What's supported is SQL statements like the following: SELECT Categories.CategoryID, CategoryName, AVG(UnitsInStock) AS AvgUnits FROM Products JOIN Categories ON Categories.CategoryID = Products.CategoryID WHERE (UnitsInStock > 0) AND (Discontinued = 0) GROUP BY Categories.CategoryID, CategoryName HAVING (AVG(UnitsInStock) > 30) ORDER BY AvgUnits DESC

This code is a cleanup of earlier code submitted for getting the middle text of a string. I've added proper error handling and naming conventions.

This code extracts undetermined-legth-strings (separated by delimiter) from a single string. NOTE** UPLOADED A NEW EXAMPLE, LAST EXAMPLE HAD A MISTAKE IN IT. SORRY ABOUT THAT.

Ever wanted the ability to run a 'smart' search, ie, with full and's, or's, not's, xor's, brackets (even nested brackets), and "". Basically like a search engine? This is the vb code to do it for you. An example expression would be: animals and ((cats or feline) or (dogs or canine)) and "is cuddly" Very usefull and very easy to implement

This Class will convert a variety of numbers passed as string to their long winded english couterpart. It handles currency, Decimals and percents. The range is -999,999,999,999,999 to 999,999,999,999,999. returns an error description if it occurs.

Extended stored procedure that shows RAM allocation of a SQL Server. Look at the code for an explanation of the output.

According to research at an english university, it doesn't matter in what order the letters in a word are, the only important thing is that the first and last letter is at the right place. The rest can be a total mess and you can still read it without problem. This is because we do not read every letter by it self but the word as a whole. This 'never seen before' code can make such words for you, it saves the first and last letter and makes a 'total mess' of the middle ones! Update includes: Now the program is faster and the code is easier to read, this because it is more compact now. Thanks to Roger Gilchrist for sending me this optimalizations! (NOTE: there is a project like this submitted a while after I submitted mine. That code is not a rip, it works totaly diffrent then this one does)