While looking at a few methods for parsing a string I came across a method for removing unwanted characters from a string. It involves looping through a string and using the Like Operator to determine if any given character is wanted.
Continue Reading »
string
Is That String Really Empty?
While testing out some operations on a Variant, I ran across an interesting problem. One of the variables I used was a fixed-length string.
Turns out, this type of variable fails the Len test: it returns the predetermined length of the variable even if you don't set it to any value! I recognize, however, that this may be only a minor problem. Who uses fixed-length string variables that often anyway?
Building strings for arrays
I don't know about you, but I hate building strings for arrays. That's where you have to wrap each string in double quotes and delimit with a comma, like this:
From
"Once upon a time"
to
"Once","upon","a","time"
Invariably, I make a mistake in typing (stupid fingers!) and have to correct it. So I came up with a way to generate it automatically. Enter the QuoteString function!
Follow Me