Advanced String Functions
Asc
This function returns the ASCII character code for a character. This is particularly useful for something that encodes passwords: you could take 1 from the character code, just as a simple code.
Asc("A") returns 65 Asc("A happy elephant") returns 65 (it takes the first character only)
Syntax:
Asc(string)
Format$
To explain this function in detail would need a lot more room than this quick round up of advanced string functions allows. So, I will just touch on some of its functionality. There is lots of information in the help file about it, so try looking there for more in-depth information.
Format(123.4, "#####.##") returns "123.4"
Format(123.4, "00000.00") returns "00123.40"
Format(123456.789, "###,###.#") returns "123,456.7"
Format(#07:14:23#, "hh:mm AM/PM") returns "07:18 AM"
Page 2 of 2
This article was originally published on November 20, 2002