Results for "Category: String Manipulation"

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

This code Searches AltaVista.com and puts the results into a listview. The your can click any result and it is opened in the default browser.Please put your comments down, and if you find any bugs pls put then down too. :)

Changed the interface a bit, made the labels for the menus into textboxes so they can go *over* the rich text box, thus letting me make it bigger. Added the ability to password protect the program, (the password is encrypted then flipped backwards), and there is now a "QuickCrypt" function that lets you select a file, encrypt it, then save it, without using the open then save and so on options from the menus. Still trying to figure out compression! If you have any idea on how I could get a *nice* way of compression for ALL 255 characters, aside from using the zlib dll, tell me! If you have not seen the other version of this program, 2.2, this program encrypts all 255 characters in a decently strong way. Oh, also added the small part to see that time it took to encrypt the file, it slows down the process though!

This VERY short function compares 2 strings and returns a number (that can be converted into percentage if multiplied by 100) that represents how closely related 2 strings are. For instance "ABCDE" and "ABCDF" would return say.... .8 (80%). Great for suggesting fixes for spelling errors et cetera. Feel free to use, abuse, and manipulate the code however you want, I'm sure it's not original, but I know it can be helpful :).

This is a simple shopping cart made using recursive scripts. The entire system is stored in 1 asp file and 1 mdb for the data storage.

This program creates and view's NFO and DIZ files. This is the newest version of the program. New features include 80+ tools to make your NFO or DIZ file, it also has 10 customizable tools. bizzyNFO4 also lets you use multiple tools at once. 7 to be exact. There are also many many more features, many. Give this program a try. Also if you used it please rate it if you can. That will be greatly appreciated. Also please leave me some comments, to keep in mind when I create the next version.

This program search a string in multiple documents at the same time and lets you open the match documents from the program. I`ve had add some new features like select the extension of documentes, view only the 10 first matches and save the configuration to use in another sesion. I`ve fixed the program for this usefull version. Thank yours for this chance.

Functions on Strings. Those seem to be difficult but are actually very easy. Count Characters, Vowels, Lenth of String etc.