Results for "Category: String Manipulation"

I really miss DAO/ADO. I like ADO.NET's disconnected DataSet but not it's syntax. So I wrote this class to let me use DAO/ADO-like commands with ADO.NET operating in the background. It is really great for Looping thru in code. This is Version 3, with some bug fixes.

This program was devised to help novices and learners encompass a better understanding of basic string manipulation. It uses such functions as Left, Mid, Right, Replace, etc. Also allows you to save and open text files with API.

Ported to VB from a Java port of the GNU Diff implementation. The basic algorithm is described in "An O(ND) Difference Algorithm and its Variations", Eugene Myers, Algorithmica Vol. 1 No. 2, 1986, p 251. It's released under the GPLv2

"PARSE" function converts search string (like in altavista/with pluses, minuses and quotations) into SQL query string for database search. To make this work in your database, you need to replace "table" and "field" words with appropriate values for your database. It's done in VB6 but will work in other versions as well.

Here is an example of how one can count the number of appearances of a specified character in a given textstring. Included is a little project file with a form. The code is quite understandable. Actually it is beginners code. I just submitted this as a sequel to another submission here on PSC. Not that I find the other submission bad, but to show another way of doing things.

This function adds st, nd, rd, or th to the end of a string of numbers based on what the number is. For example, the following code can produce the following output, "Thursday, November 23rd, 2000" : Format(Date, "dddd, mmmm ") & FormatFancyNumber(Day(Date)) & ", " & Year(Date)

A password cracker simulator using a permutation of a byte array algorithm. Hold on to your hat this class is fast!

Comparing connection string: Aceess Vs. SQL server --------------Access ---------------- OleDbConnection mycnn = new OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0;Data Source = C:\\ManasEcomm\\Wine1\\pro2.mdb"); --------------SQL SERVER----------- SqlConnection mycnn = new SqlConnection("server=manas4;Integrated Security =SSPI; Initial Catalog=pubs"); SqlDataAdapter mycmd = new SqlDataAdapter("SELECT * FROM employee", mycnn);

Shows the database's schema and the table's data

Complete, ready to use, SoundEx function to encode a passed alphabetic name and return a six character Daitch-Mokotoff code following the Daitch-Mokotoff (D-M) rules available at the sites listed in the source code. The D-M algorithm resolves some deficiencies that occur in the older Miracode/Soundex system (also known as the "Russell"/NARA system - used by the US Census Bureau). The benefits include: 1) Six meaningful letter sounds (versus four so that Peters is different from Peterson). 2) The initial letter is also sound encoded. 3) More sound variations (10 basic codes versus seven and double code sounds). 4) Improves sound matching for Jewish, Slavic, and Germanic names. Coded as a VB module with Public SoundEx function. Uses simple visual basic coding, and should be usable in anything supporting VB/VBA. Code Zipped because it is a complete module. Code commented

Just quit smoking? This simple tool keeps you informed of your progress.

Conversion factors derived from 2001 ASHRAE Fundamentals Handbook (SI) page 37.2

This will allow you to edit a collection of Access database's table data online. The bulk of the working code was originally submitted by Cakkie, and I added some new features, like secure login, the ability to select any database/table in a predefined directory, query tool, paging, result set count, and a new CSS style schema. I tested it a bit, but please report any bugs that may occour. View the ReadMe.txt file for setup instructions. UPDATED 9/12/2002

This demo allows you to compare and benchmark 3 methods of XML Parsing available to VB. 1. String Manipulation The first method is basic VB string manipulation, using functions such as Instr() and Mid(). 2. MSXML Document Object Model The second method uses the DOM methods provided with MSXML. 3. MSXML 3.0 SAX2 The final method uses the new SAX2 technology provided with MSXML 3.0. The benchmarking results will prove that SAX2 scales linearly while the DOM and VB string methods scale exponentially. SAX2 proves to be a highly scalable solution for parsing large XML recordset. This demo will be useful for those who are interesting in learning about XML parsing in VB, and especially useful for those who want to take advantage of Microsoft's new MSXML SAX2 technology. All the VB wrapper classes you will need are included with this demo. Before you run this demo, you will need to install Microsoft's MSXML 3.0 library. For instructions, see the Instructions.txt file included with the project. Don't forget to vote!!!

This code can do many modifications to a string. (See screenshot for more details). I was tired of seeing programs that showed only one string modification so I programmed something that could modify a string in more than one way. (Code is explained).

Allows a programmer to manipulate a string of tokens such as: "Jane;Paul;Harry" or "Name:Paul;Age:21;Gender:M". Note that this routine allows for individual tokens or for tokens that have a key attached. Tokens can then be retrieved by position or key.

Youve all seen that stup1d squiggly text people use in chatrooms etc... You CaN NoW eaSiLY WRiTe LiKe a ReaL LaMeR (ÎÑ ÇÃ$Ê ÝÖú ÑÊÊÐ †Ö fâkÊ TÖ ßÊ §úçH...). No delamerizer as of yet :( pulls the text from a textbox and uses the [ replace ] command... no commenting... but it seems reasonably easy to understand.. :)... jB

Utilises a lot of the string manipulation commands to do just about anything with a line of text. Some of the more advanced functions i learnt as i went along, so they arent gonna be particually perfect! I hope this should be more or less bug free tho... I designed this to be for beginners / intermediatte needing a hand geting going in this field. Im sure other people are gonna have string manipulation tutorials already on PSC, but what the hell! have another one... :) Beginners: if you have any problems getting the code to work, email me at the address at end. tHE_cLeanER

This code will search a string for a given starting point(strFind) and a given end point(strSentinel) and return all the text in between. You can also add to the length of the start point if you don't want to include a number of unknown characters in the result

Increments any serial number string up to the length of the original string passed to the function. Allows serial string to have delimiters. This could be useful to anyone that require automatic incrementing of a number, such as a job number, receipt number, etc