Some string functions and tips

Technorati Tag: String, vbcrlf, VBA, split

As follows:

1.  

   Several Characters

1. CHR (9)Tab vbtab
2. CHR (10)Line feed
3. CHR (13)Carriage Return vbcrlf
4. CHR (32)Space, or yesSpace (1)
   Msgbox Cities (1) & CHR (13) & Cities (2)

2. Quoted text embedded in a text string requires an additional set of quotation marks, as in"" Test.doc "".

3. To get the same result, you can replace CHR (9) with a VBA constant: vbtab.

4. Note: vbcrlf is a string of 2 characters. For example, if the last character of a string is vbcrlf, you can use the right function to retrieve the last character and ask whether it is equal to vbcrlf. The answer is false; however, if you take the rightmost 2 characters, you can get the vbcrlf

5. Isnumeric checks whether all strings are numbers.

6. Right, left, mid, and instr are all easy-to-use functions used to access individual characters in strings.

7. Format FunctionUsed to format strings

8. Split Function

1. 1. Public sub test ()
   2. Dim shoppinglist as string
   3. Dim shoppingitem () as string
   4. Shoppinglist = "milk, eggs, bread"
   5. Shoppingitem = Split (expression: = shoppinglist, delimiter: = ",")
   6. Msgbox "0:" & shoppingitem (0) & CHR (13) & "1:" & shoppingitem (1) & CHR (13) & "2:" & shoppingitem (2)
   7. End sub