find text in html code and put pieces into a table

I have lots of records with an ID and html code. On that html page there are funky chunks of code that I highlighted in red below:

more html...

Bacon ipsum dolor amet salami t-bone pancetta, chuck leberkas tenderloin pork loin. Filet mignon strip steak pig venison meatball chuck spare ribs [[--ContentED.9uFvErVUB342rwukUx3H9||Shank sausage pancetta chicken||1758699LJ||Article--]] and [[--ContentED.V1cnQOilHA5234rs4z27ZuA7||Short ribs andouille short loin pork||1753243LJ||Article--]] for more information.

[[[[AssetED.w8dho5pdsfserwerJ0Q7]]]]¶
[[[[AssetED.icqFyEsdf354wtgs0HwYqwM9·height="305"·width="574"]]]]¶

...more html

I'd like to copy the ID (let's say 2345 for the example above) and the four (or whatever number it is) chuncks into a table that looks like this:

What methods can you suggest? Thanks! - Jimmy

Regex

Preparation

Accepted answers

michael_treadwell

The RegEx pattern (\[{1,4}.*?\]{1,4}) should match strings found between 1 and 4 brackets including the brackets:

( begins a marked group
\[{1,4} matches anywhere between 1 and 4 left bracket characters
.*? matches all characters in a lazy (non-greedy) way
\] matches anywhere between 1 and 4 right bracket characters
) end a marked group

Use the RegEx Tool and check tokenize with the pattern above. Select 'Split to Rows'. I've also attached the module so that you can see for yourself.

bracket-parse.yxmd

All comments

MarqueeCrew

I've got an idea brewing. I might replace everything between ] and [ (that isn't another ']') with a delimiter.

That gives you JUNK followed by [. You can eliminate the junk. Then you have ] followed by JUNK. You can eliminate the junk.

You'll then have to format the data as required. I'll check in the morning to see if you've solved this.

Mark

michael_treadwell

The RegEx pattern (\[{1,4}.*?\]{1,4}) should match strings found between 1 and 4 brackets including the brackets:

( begins a marked group
\[{1,4} matches anywhere between 1 and 4 left bracket characters
.*? matches all characters in a lazy (non-greedy) way
\] matches anywhere between 1 and 4 right bracket characters
) end a marked group

Use the RegEx Tool and check tokenize with the pattern above. Select 'Split to Rows'. I've also attached the module so that you can see for yourself.

bracket-parse.yxmd

jimmys

Michael,

Beautiful. That worked as I had hoped. Loved learning that too. I have been needing to learn RegEx more and this helps motivates me to do it. Thank you! -Jimmy

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235