在表格怎么把SKUID的数值一次性分行提取出来
{"price":"149.80","stock":"2","skuId":"4886100427583","oversold":false},";20518:6145171;1627207:381790192;":{"price":"149.80","stock":"2","skuId":"4886100427567","oversold":false},";20518:3727387;1627207:28334;":{"price":"149.80","stock":"2","skuId":"4886100427541","oversold":false},";20518:6145171;1627207:420804828;":{"price":"149.80","stock":"2","skuId":"4886100427588","oversold":false},";20518:7539404;1627207:420804828;":{"price":"149.80","stock":"2","skuId":"4886100427591","oversold":false},";20518:28315;1627207:420804828;":{"price":"149.80","stock":"2","skuId":"4886100427585","oversold":false},";20518:6145171;1627207:26106744;":{"price":"149.80","stock":"2","skuId":"4886100427574","oversold":false},";20518:28316;1627207:28341;":{"price":"149.80","stock":"2","skuId":"4886100427530","oversold":false},";20518:28317;1627207:420804828;":{"price":"149.80","stock":"2","skuId":"4886100427587","oversold":false},";20518:28316;1627207:28866;":{"price":"149.80","stock":"2","skuId":"4886100427544","oversold":false},";20518:28317;1627207:26106744;":{"price":"149.80","stock":"2","skuId":"4886100427573","oversold":false},";20518:115781;1627207:420804828;":{"price":"149.80","stock":"2","skuId":"4886100427589","oversold":false},";20518:28315;1627207:384162301;":{"price":"149.80","stock":"2","skuId":"4886100427578","oversold":false},";20518:7539404;1627207:26106744;":{"price":"149.80","stock":"2","skuId":"4886100427577","oversold":false},";20518:3727387;1627207:26106744;":{"price":"149.80","stock":"2","skuId":"4886100427576","oversold":false},";20518:7539404;1627207:384162301;":{"price":"149.80","stock":"2","skuId":"4886100427584","oversold":false},";20518:28317;1627207:381790192;":{"price":"149.80","stock":"2","skuId":"4886100427566","oversold":false},";20518:28316;1627207:26106744;":{"price":"149.80","stock":"2","skuId":"4886100427572","oversold":false},";20518:28315;1627207:381790192;":{"price":"149.80","stock":"2","skuId":"4886100427564","oversold":false},";20518:3727387;1627207:28341;":
数据的行列如上图所示。(VBA代码如下）
Sub SKUID数值()
Dim rng As Range
Set regx = CreateObject("vbscript.regexp")
With regx
.Global = True
.Pattern = "[0-9]{10,}"
For Each rng In Range(Range("A2"), Range("A2").End(xlDown))
Set mat = .Execute(rng)
For Each m In mat
Cells(rng.Row, 2) = m
Next
Next rng
End With
End Sub