我该如何从一个VBA字符串数组中提取第n个元素?
我有一个字符串,像这样:TEST - 2017/01/20 = 发票
我希望尽可能简洁地提取出第二和第三个元素。我试着类似于JavaScript的方式去做,但这并不可行,所以应该有一种VBA的方法:
Dim Report As String
Dim CurrLine As String
Dim CurrDate As String
Dim CurrTask As String
CurrLine = "TEST - 2017/01/20 = Invoice"
CurrDate = Trim(Split(CurrLine, '-')[1])
CurrTask = Trim(Split(CurrLine, '=')[1])
Report = Report & CHR(34) & CurrDate & CHR(34) & "," & CHR(34) & CurrTask & CHR(34)
//result: "2017/01/20","Invoice"
Join
函数连接字符串,并用单个正则表达式替换所有内容。 - Slai