Results for "Category: String Manipulation"

Makes Twisted Text, Kinda Like Scrambled

Convert Columns To Rows for Excel. Select Cells and copy to clipboard. Click then past back to excel.

This function takes a long string of text, splits it up into lines for printing or displaying, then returns the new string. Like the newspaper, it doesnt cut off words, it carries them over to the next line. It includes a function to check for the longest word so you dont accidently ask for a column width smaller than your largest word.

If you ever wanted to have a string with quotes inside this is a handy tip.

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 code will cycle through a text box or rich text box line by line, select the line and place it into a string array. The array will then be passed to another method where it will be placed into a list box excluding the blank lines. I've seen other code like this but if there is no ending vbCrLf then the last line of the box is not read, I've fixed this and showed how to extract the line information and how to use it. The code is slowed down using a pause routine that I made about a year ago.

Drag and Drop a Free File onto the List Box. The Application opens the File as Binary and loads it into Buffer Space and scans the contents for Virus Strings. Very easy to do, and commented. It only does a single file right now, looking to add Directories upcoming.

VB forgot to add a Function strip out all those LEADING, TRAILING and EXTRA spaces in ONE Function. I have seen many attempts at doing this but think mine does it in the least amount of code. Note: = literal SPACE

Takes a number and returns a word expression for that number. Example: 123.01 returns "One Hundred Twenty-three And 01/100". Very useful for printing checks.

A sample VB program that demonstrates how to find and select words in a Textbox. Very simple but quite useful! Please rate!

Actually this is kind of fun. This program genaerates 1000000 completely random letters and then uses the microsoft Word Spell check object to look for real words. You can specify the minimum length of text to search for as well as maximum and it will highlight real words. i put an Algorythm that looks for words based on each character position, for example, if "WHOLE" is found it will return 3 words, "Whole", Hole", and OLE". You would be surprised to see some of the words that are generated. Oh well, good for a dyno test on your computer at least. Comments and votes are greatly appreciated.

Compresses strings, most effective on bitmap files

This short and sweet function accepts a string containing text to be spell checked, checks the text for spelling using MS Word automation, and then returns the processed text as a string. The familiar MS Word spelling dialog will allow the user to perform actions such as selecting from suggested spellings, ignore, adding the word to a customized dictionary, etc.

This routine was designed to act as a numbers-only mask for any TextBox Keypress event. Simply call it from any KeyPress event and feed it the KeyAscii return value.

This is a class module that performs regular expression searches in a string.

Want to sort 5,000 10-byte strings in about 1/10th of a second? This will do it (at least on my PII-233!). The insertion sort manages the same task in about 60 seconds (even when optimized it still took about 15 seconds on the same machine).

It will erase any non-alphanumeric characters from a string rapidly. Usefull if you want to check strings for non-valid characters. Strings such as email or web addresses, you can even make so that only numbers can be entered in, for example, a text box.

RECURSIVE DESCENT PARSER FOR NUMERIC EXPRESSIONS

Converts a name or word string to a four digit code following Soundex rules. Similar code is used by geniological groups and the US Census Bureau for looking up names by phonetic sound. For example, the name Darrell can be spelled many different ways. Regardles of how you spell it, (Daryl, Derrel, Darel, etc.) the Soundex code is always D640. Therefore, you assign a field in your database to the Soundex code and then query the database using the code, all instances of Darrell regarless of spelling will be returned. Refer to the code comment section for more information.

This function converts amount in words with supplied currency parameters. e.g. AmtToWords(12345.01, "GB POUND", "PENNY", "GB POUNDS", "PENNIES") will return GB POUNDS TWELVE THOUSAND THREE HUNDRED FORTY-FIVE and ONE PENNY ONLY