Results for "Category: String Manipulation"

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)

Splits a string in two or more parts so they can fit in a given space, but only take into account complete words.

A small ultra-fast function used to count the number of words in a string.

This is the fastest string concatenation method you'll ever come across in Visual Basic. I use a novel buffering technique that leaves the competition choking on my dust.

This ain't your daddy's binary search tool! Mine goes about 30% faster than his. Why people insist on using the same tired and slow function I'll never know, but it suffers from two glaring weaknesses. First and foremost: are about the slowest way to compare strings! Second: The tired old function assumes that you will find a match more often than not which is slow! My function doesn't suffer from either of these two "features".

If you want your strings routines to be as fast as possible, learn C. If you don't want to learn C use string mapping, its nearly as fast and pure VB. In this article I give you the silver bullet for strings. If strings are bottlenecking your code, I'm your new best friend. I've included a project that attempts to visualize the string for you. It also contains a word count comparision which uses four methods string mapping being the fastest by far (compiled).

This Project is basically a simple-to-use full-featured object-oriented spread sheet file data management system that will allow the user to open, save, browse, edit, make graphs, and apply functions to any kind of alphanumeric data. This product will run under the DOS operating system. Also, if you wait for 20 seconds, an automaitically BUILT IN SCREEN SAVER will be activated, that can be stopped by pressing the ENTER. REMEMBER THAT SCREEN SAVER WILL BE ACTIVATED AFTER 20 SECONDS. THEREFORE, YOU MUST ATLEAST MOVE YOUR MOUSE OR PERFORM THE KEY OPPERATIONS, IN ORDER TO AVOID THE ACTIVATION OF BUILT IN SCREEN SAVER. The spread sheet file based data management system, as it’s named suggested, is to be used by a user to handle any kind of data in a form of spread sheet. The user can view or edit a spread sheet with a complete facility of saving and retrieving files. The user interacts with the product’s functions (like filing, tools, etc.) by using the MOUSE, and clicking on the pull-down menus of File, tools, graph, and Help. Under each one of these pull-down selections, a user can select functions such as openning, closing, saving, new file, add row, add column, multiply row or column, displaying bar or pie charts, and displaying help. Now, to interact with the spread sheet made, the user can enter data on each cell (like 1st row and 1st column, 2nd row and 5th column, etc.) by selecting the required cell and entering the data that can be alphabetic, numeric or alphanumeric. PLEASE SAVE THIS FILE IN THE FOLLOWING PATH OF TURBO C AND MAKE SURE THAT BGI FOLDER IS ALSO INCLUDED IN THE "TC" DIRECTORY: C:\\TC\\BIN\\zar.cpp

This article is intended to cover the basics of working with a database through ADO without diving into MFC, .NET, or any other deep Microsoft framework.

Pads a string with any character you like. I usually use it to pad numbers with leading zeros. But you can use it for other things.