|
$trings |
Function |
Description |
| LTrim$ |
LTrim$(S) returns a copy of S without leading spaces. |
| RTrim$ |
RTrim$(S) returns a copy of S without trailing spaces. |
| Trim$ |
Trim$(S) returns a copy of S without leading or trailing spaces. |
| Val |
Val(S) returns the numeric value contained in S (non-localized). |
| CInt |
CInt(S) returns the integer value contained in S (localized, rounded). |
| CDbl |
CDbl(S) returns the double floating point value contained in S (localized). |
| LCase$ |
LCase$(S) returns a copy of S with lower case letters. |
| UCase$ |
UCase$(S) returns a copy of S with upper case letters. |
| Left$ |
Left$ manipulater. |
| Right$ |
Right$ manipulater. |
| Mid$ |
Middle manipulater. |
| |
|
| StrConv(vbLowerCase) |
StrConv(S,vbLowerCase) returns a copy of S with lower case letters. |
| StrConv(vbUpperCase) |
StrConv(S,vbUpperCase) returns a copy of S with upper case letters. |
| StrComp(vbBinaryCompare) |
StrComp(S1,S2,vbBinaryCompare) compares string S1 and S2 based on their Unicode values. |
| StrComp(vbTextCompare) |
StrComp(S1,S2,vbTextCompare) compares string S1 and S2 in a locale-dependent, case-insensitive way. |
| InStr(vbBinaryCompare) |
InStr(x,S1,S2,vbBinaryCompare) looks for S2 in S1, starting at position x, in a locale-independent, case-sensitive way. |
| InStr(vbTextCompare) |
InStr(x,S1,S2,vbTextCompare) looks for S2 in S1, starting at position x, using text compare. |
| InStrRev(vbBinaryCompare) |
InStrRev(S1,S2,x,vbBinaryCompare) looks for S2 in S1, from position x back to 1, in a locale-independent, case-sensitive way. |
| InStrRev(vbTextCompare) |
InStrRev(S1,S2,x,vbTextCompare) looks for S2 in S1, from position x back to 1, using text compare. |
| Replace(vbBinaryCompare) |
Replace(S1,S2,S3,x,y,vbBinaryCompare) replaces S2 with S3 in S1, starting at position x, max y times, in a locale-independent, case-sensitive way. |
| Replace(vbTextCompare) |
Replace(S1,S2,S3,x,y,vbBinaryCompare) replaces S2 with S3 in S1, starting at position x, max y times, using text comparison. Replace(Text1$, Text2) |
|
| |
InStr([start,] string1, string2 [, compare]) |
- start
- Optional. Character position where the search starts. If omitted, the search starts at the start of string1, position 1. Valid input values: 1 to Len(string1)
- string1
- The string to search in. Can be Null.
- string2
- The string to find. This is the text you want to find inside string1. It is usually shorter than string1. Can be Null.
- compare
- Optional. Specifies the type of string comparison
|
| |
InStr returns one of the following values:
- Null if either string1 or string2 is Null.
- start if string2 is empty.
- Character position of the first occurrence of string2 in string1.
- Zero if string2 was not found in string1.
|
Special cases:
- InStr(string1, "") returns 1 if string1 is not empty.
- InStr("", "") returns 0.
- If start exceeds the length of string1, there is never a match and InStr returns 0.
|
| InStrRev – Reverse search |
InStrRev searches the string in reverse order: from the end to the start. It locates the last occurrence of a string within another.
InStrRev(string1, string2 [, start] [, compare])
Note how the parameters are in a different order than with InStr. Also note that InStrRev does not reverse the input strings: "ABC" does not match "CBA".
InStrRev runs slowly, especially on a long string1. Use InStr when you can. More |
| InStrB – Byte search |
InStrB treats the input and search strings as byte arrays, not as regular strings. As you may know, VB uses Unicode strings. InStrB lets you by-pass Unicode functionality and use byte arrays as if they were strings.
InStrB([start,] string1, string2 [, compare])
Instead of character position, InStrB returns the byte position of string2 in string1. InStrB should not be used for regular string processing. |
|
|
#
1325
|
Strings :: by __Doc_ |
|
|
 |
|