|
本帖最后由 yuanexl 于 2019-3-23 15:00 编辑
工人4人,电焊机1台,吊车1辆,发电机1台,工人2人,电焊机1台,发电机1台
各位老师帮帮忙 用Vba 把上面的字符串 汇总如下
工人6人,电焊机2台,吊车1辆,发电机2台
试了一上午 也没找到 好办法 ,先谢谢了
- Sub s()
- Dim arr1()
- Dim rng
- sr = "工人4人,电焊机1台,吊车1辆,发电机1台,工人2人,电焊机1台,发电机1台"
- arr = Split(sr, ",")
- ReDim arr1(UBound(arr))
- ReDim arr3(UBound(arr))
- For s2 = 0 To UBound(arr)
- Set regx = CreateObject("VBScript.RegExp")
- With regx
- .Global = True
- .Pattern = "\D" '数字
- t = .Replace(arr(s2), "")
- arr1(s2) = t
- End With
- Next
- For t1 = 0 To UBound(arr) - 1
- For t2 = t1 + 1 To UBound(arr)
- If Left(arr(t1), 2) Like Left(arr(t2), 2) Then
- t = Replace(arr(t1), arr1(t1), Val(arr1(t1)) + Val(arr1(t2)))
- rng = rng & "," & t
- End If
- Next
- Next
- End Sub
复制代码 得到下面的结果
",工人6人,电焊机2台,发电机2台"
现在的问题是 多了个 逗号 少了 吊车1辆
求指点 谢谢
|
|