topic Re: Extract Table in Event in Reporting

Extract Table in Event

RobertRi — Sat, 28 Nov 2020 15:26:07 GMT

Hi Community!

I have a problem to extract a table in an XML event.

The data looks like this

Now I want to have the fields for cartype, quantity and price (VW;1;30.000;).
So that I can summarize the whole sellings from one day.
Could you please help me with that?

Thank you very much!
Rob

Re: Extract Table in Event

ITWhisperer — Sat, 28 Nov 2020 16:52:09 GMT

| spath path="data{@text}" output=sales | rex field=sales max_match=0 "\n\s+(?<cartype>[^;]+);(?<quantity>\d+);(?<price>[^;]+);"

Re: Extract Table in Event

RobertRi — Mon, 30 Nov 2020 08:14:59 GMT

Thank you very much!

Re: Extract Table in Event

RobertRi — Tue, 01 Dec 2020 08:13:13 GMT

HI ITWhisperer!

Thank you very much for your answer, whith it I have an overview about my data.

Now I have a second question, regarding the prices.
It seems if there are more than 1 matches, the data will be stored like an array in the field.
If I export it to an csv it looks like this:

VW,2,30.000,0000
25.000,0000,

I have tried to round the price to a 2 digit value after the comma, but this does not work.

How can I grab each item in the field and modify it with an eval command?

Regards
Robert

Re: Extract Table in Event

ITWhisperer — Tue, 01 Dec 2020 09:48:08 GMT

What does the XML look like in this instance?

Re: Extract Table in Event

RobertRi — Tue, 01 Dec 2020 10:00:17 GMT

It's the same like above except that the prices has multiple decimal places after the comma.

Re: Extract Table in Event

ITWhisperer — Tue, 01 Dec 2020 10:02:55 GMT

| spath path="data{@text}" output=sales | rex field=sales max_match=0 "\n\s+(?<cartype>[^;]+);(?<quantity>\d+);(?<price>[^;,]+);"

Just add a comma to the exclusion list for the price.