Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Strings: Index Of Articles

 
 
Parse one field's data into multiple fields

How to "break" the values in one field (say, Name) in multiple fields (FirstName, LastName)

Extract characters from a string containing both numbers and characters

How to extract characters from a string containing both numbers and characters

Parsing character separated string into individual components

How to tokenize strings 

Replace a character with another within one string

How to replace a character

Capitalize first character of every word automatically

Use StrConv in VBA5+ or a custom function in prior versions to proper case a word

Convert all text to Upper-Lower case

Use LCase or UCase to switch between cases

Increment Numeric portion of a string

Use concatenation and Right$ to deal with a number separately

Names with Mixed cases

How to proper case words taking into account names with mixed case (eg. McPherson)


1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer