有一个函数可以解析像SUM(H).
此函数使用正则表达式查找带参数的函数名称,然后只找到参数,在简化版本中,只取一个参数。
如何修改正则表达式以使函数名属于单独的组?
Protected Function parse_formula(formula As String) As String
Dim pattern As String = "\b[^()]+\((.*)\)$"
Dim regex As New Regex(pattern)
Dim match As Match = regex.Match(formula)
Dim arguments = match.Groups(1).Value
Dim argument = Regex.Match(arguments, "([^,]+\(.+?\))|([^,]+)")
Return argument.Value
End Function
1 个回答