Lua pattern: how to fetch the required string

Question

I have a string as mentioned below, basically data is coming to me in excel file. Some rows are proper data and for these proper data rows I am able to fetch what I need using the lua pattern. Below is the proper data row

2011/02 ARRTC AAUUMCO ZZITNWMOBILE COMMUNICATIONS CENTER ARRTC-AAUUM-TBT-2011-02 0.00 AAUUM_ARRTC_0211_TBT 18.03 18.03 EUR 1.14977 20.73 20.73

and I am using below pattern and everything is working fine.

rPattern = "(%d%d%d%d%/%d%d)%s*(%w%w%w[%w%d][%w%d])%s*(%w%w%w[%w%d][%w%d]).-[%u%d%-%s]-([%d%.%,]+)%s*([%u%d_%-]-)%s*([%d%.%,]+)%s*([%d%.%,]+)%s*(%u%u%u)%s*(%d+%.%d*)%s*(.-)\n"

Now some rows are coming with HTML tags, means my data is inside the html tags. The only trick I need is to fetch my required string within the HTML tags. the bugged row is

2011/02 ARRTC   AAUUMCO ZZITNWMOBILE COMMUNICATIONS CENTER  ARRTC-AAUUM-TBT-2011-02 0.00    <a href="/cgi-bin/recon_detail?rectent=AAUUM&benificary=ARRTC&period=2011/02&svctype=Voice">AAUUM_ARRTC_0211_TBT</a>    18.03   18.03   EUR 1.14977 20.73   20.73

now from the above row I want to fetch AAUUM_ARRTC_0211_TBT

I am trying trying and trying but unable to do it. Can somebody will help me to fix my above patternd?

Thanks

What is the exact thing you are looking for? Is it the first content between matching tags? — Stuart P. Bentley
– Stuart P. Bentley, Commented Jun 30, 2011 at 19:10
I have updated my post. Hope it will give you some more detail — Shax
– Shax, Commented Jul 1, 2011 at 8:43

lhf · Accepted Answer · 2011-06-30 19:23:00Z

2

Try print(str:match(">(.-)<")).

answered Jun 30, 2011 at 19:23

lhf

72.9k11 gold badges117 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shax Over a year ago

I have updated my post. Hope it will give you some more detail

Nicol Bolas · Accepted Answer · 2011-07-01 03:04:59Z

1

Lua pattern matching is incapable of parsing HTML. While the ">(.-)<" pattern would work in this particular instance, it would not be a general solution for arbitrary HTML.

answered Jul 1, 2011 at 3:04

Nicol Bolas

481k66 gold badges861 silver badges1.1k bronze badges

1 Comment

Shax Over a year ago

I have updated my post. Hope it will give you some more detail

Collectives™ on Stack Overflow

Lua pattern: how to fetch the required string

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related