(Excel) StringBuilder GetBefore

Demonstrates the StringBuilder.GetBefore method.

The GetBefore method was added in Chilkat v9.5.0.77

Download Excel Class Modules Chilkat Excel Class Modules

Dim sb As Chilkat.StringBuilder
Set sb = Chilkat.NewStringBuilder

success = sb.Append("www.chilkatsoft.com")

' The GetBefore method returns the contents of the string up to but not including
' the marker string.  If the remove flag is True, then both the returned string AND
' the marker are removed.

removeFlag = False

marker = "."

substr = sb.GetBefore(marker,removeFlag)
Debug.Print "substr = "; substr
Debug.Print "sb contains: "; sb.GetAsString()

' Output:
' substr = www
' sb contains: www.chilkatsoft.com

removeFlag = True
substr = sb.GetBefore(marker,removeFlag)
Debug.Print "substr = "; substr
Debug.Print "sb contains: "; sb.GetAsString()

' Output:
' substr = www
' sb contains: chilkatsoft.com

' If the marker is not found, and the removeFlag is True,
' then the entire string is returned and the sb is cleared.
' For example:
sb.Clear 
success = sb.Append("111--222--333--444")
marker = "--"
removeFlag = True
Do While (sb.Length > 0)
    substr = sb.GetBefore(marker,removeFlag)
    Debug.Print "substr = "; substr; ", sb contains: "; sb.GetAsString()
Loop

' Output is:
' substr = 111, sb contains: 222--333--444
' substr = 222, sb contains: 333--444
' substr = 333, sb contains: 444
' substr = 444, sb contains: