Isolating string (html)

Hi, people. Help needed and appreciated!

I have a column, named HTML. Then, many lines like this:

<div class="_2b06"><div class="_2b05"><a href="/luiz.bonamin?fref=nf&rc=p&__tn__=R-R">Fernanda Borges</a></div><div data-commentid="776884669184957_779428782263879" data-sigil="comment-body">Em qualquer raia do Paraná ou só para Unimed Curitiba? Uma fez fui ver em uma farmácia raia, e disseram que era só para Unimed Ctba...</div></div>

I need to isolate /luiz.bonamin into one collum, and the text after "comment-body"> Both are highlighted in the example.

Any thoughts?

Settings

Macros

Preparation

Expression

Data Investigation

Accepted answers

danrh

I'd advise a RegEx tool with ...

.*<a href="(.*?)\?.*"comment-body">(.*?)<.*

... as your expression and Parse as your Output Method. This will create two additional fields with the strings you're after.

Hope it helps!

solution.yxmd

danrh

This is getting pretty specific, so this might not work for all your cases, but try:

.*<a href="(.*?)(?:\?|&amp;)fref.*"comment-body">(.*?)<.*

The second part is the same, but the first part is now anchored to the "fref" tag in the code. If that tag changes locations this won't work, but for the 3 examples you provided it gets the job done. Give it a go and see if it works! If not, we might want to break these up based on which way they need to be parsed. Is there a distinction between the two formats? For instance, is "id=..." never in the first format and always in the second?

All comments

danrh

I'd advise a RegEx tool with ...

.*<a href="(.*?)\?.*"comment-body">(.*?)<.*

... as your expression and Parse as your Output Method. This will create two additional fields with the strings you're after.

Hope it helps!

solution.yxmd

Ikebonamin

Thank you so much!

It worked.

Ikebonamin

Dear Danrh;

Altough the solution you provided really worked, I failed to describe de correct scenario.

Here´s another example of the xcel file that needs to be cleaned:

1.<div class="_2b06"><div class="_2b05"><a href="/ferborges.enf?fref=nf&rc=p&__tn__=R-R">Fernanda Borges</a></div><div data-commentid="776884669184957_779428782263879" data-sigil="comment-body">Esse desconto na Droga Raia é em todas as cidades do Paraná? ?</div></div>

In this case, it´s needed to capture the bold text, into to two separated columns. That worked fine using:

.*<a href="(.*?)\?.*"comment-body">(.*?)<.*

BUT, in the same xcel file, we have a second type of syntaxe:

2. <div class="_2b06"><div class="_2b05"><a href="/profile.php?id=100008871755952&fref=nf&rc=p&__tn__=R-R">Celina Baraviera</a></div><div data-commentid="776884669184957_781634255376665" data-sigil="comment-body">Esse desconto na Droga Raia é em todas as cidades do Paraná? ?</div></div>

These two kinds of lines alternate hundreds of times...

-> as you can see, I cant clean both type of lines at the same time. I tryed, bu as a newbie it seems impossible!!! . If you could help, once more, it would be great. And I promisse this is the last time....

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703