RegEx to parse string

Hi everyone,

been looking for a solution for about a week, but apparently RegEx can be used in about 54,658 different ways, and none of the stuff I found was clear enough (or easy enough ) to understand. I hope someone here can help...

I have a file which contains 15,000 of the following (for those interested: it's the data file for the Auctioneer add-on of WoW):

{\"|cffffffff|Hitem:23425:0:0:0:0:0:0:1624370944:80:0|h[Adamantite Ore]|h|r\",65,\"Trade Goods\",\"Metal & Stone\",nil,67919,3,1314985659,\"Adamantite Ore\",\"Interface\\\\Icons\\\\INV_Ore_Adamantium\",1,1,1,1,67919,0,76466,0,false,\"Infernuus\",0,8916,23425,0,0,0,1624370944,}

I would need to decompose it to (but in columns):

cffffffff
Hitem:23425:0:0:0:0:0:0:1624370944:80:0
Adamantite Ore
65
Trade Goods
Metal & Stone
nil
67919
3
1314985659
Adamantite ore
Interface\\\\Icons\\\\INV_Ore_Adamantium
1
1
1
1
67919
0
76466
0
false
Infernuus
0
8916
23425
0
0
0
1624370944

Could someone please give me some clear advise on how to implement this in VBA?

Thanks a bunch for any feedback!

Please Login or Register  to view this content.

etc.

Originally Posted by snb

Please Login or Register  to view this content.

etc.

Thanks for the reply, but I think I wasn't clear enough. The 15,000 items are constructed the same as the example, but contain different data (so it's not all "Adamantite Ore", or "Trade Goods"). That's why I need some pointers on RegEx and patterns (and a way to run this in VBA).

Sorry for the confusion!

whispers: ...bump...

Please read my post again and try to grasp the code.
It isn't meant for one string only.

Does it even compile?

snb,

Your signature blatenly states, avoid using code you don't understand.. .yet you post code very few understand.

What does:

It isn't meant for one string only.

mean?

please have the decency to explain the code, rather than throw one-liners and then tell users who are trying to implement the code to "try to grasp the code".