Object Reference
- Classes
- Command Interface
- External
-
General
-
xf_Controls
-
xf_DbConnect
-
xf_General
-
xf_Interact
-
xf_StringCaseInsensitive
-
xf_StringCaseSensitive
-
- System Core
- System Library
xf_StringCaseInsensitiveString Functions
Public Function SafeMid (
s As String,
StartChar As Long,
Optional Length As Long = 0
) As String
Same as the Mid() VBA builtin string function, but if there's an error just return the empty string.
s as String
The string to search
StartChar as Long
The start position of the substring
Optional Length as Long = 0
The number of characters to return, or -1 for the rest of the string
Call Template:
Dim s As String
s = xf.Str.SafeMid(s, StartChar)
s = xf.Str.SafeMid(s, StartChar, Length)
See Also:
Example 1:
1 2 3 | xf.Str.SafeMid("The King's counting house", 12) => counting housexf.Str.SafeMid("The King's counting house", 12, 5) => countxf.Str.SafeMid("The King's counting house", 35, 5) => |