VBA 中的子字符串

VBA中的子字符串操作是一种常用的技巧，它允许我们从一个字符串中提取出我们需要的部分。无论是在数据处理还是文本分析中，都经常会用到子字符串操作。在本文中，我们将介绍如何使用VBA进行子字符串操作，并提供一些实际案例代码供参考。

Sub ExtractLeftSubstring()
    Dim originalString As String
    Dim leftSubstring As String
    originalString = "Hello, World!"
    leftSubstring = Left(originalString, 5)
    MsgBox leftSubstring
End Sub

Sub ExtractRightSubstring()
    Dim originalString As String
    Dim rightSubstring As String
    originalString = "Hello, World!"
    rightSubstring = Right(originalString, 6)
    MsgBox rightSubstring
End Sub

Sub ExtractMidSubstring()
    Dim originalString As String
    Dim midSubstring As String
    originalString = "Hello, World!"
    midSubstring = Mid(originalString, 8, 5)
    MsgBox midSubstring
End Sub

Sub ExtractDomainFromURL()
    Dim url As String
    Dim domain As String
    url = "https://www.example.com/index.html"
    domain = Mid(url, 9, InStr(9, url, "/") - 9)
    MsgBox domain
End Sub