Hello, I have a problem extracting data from a log with format not fixed.
I explain:
each row of my log contains a mandatory tag (always present) followed by some other optional tags (so they may be present or not).
For example:
father="A"; son1="A1"; son2="A2"; son3="A3"
father="B"; son1="B1"; son3="B3"
father="C"; son2="C2"; son3="C3"
I need a query returning a table like this, where all values are correctly aligned under the respective tag:
father sun1 sun2 sun3
A A1 A2 A3
B B1 - B3
C - C2 C3
OK, I must use "rex" statement to identify "father", "sun1", "sun2", "sun3" values.
But when, after this, I use "table" statement to see the results, I obtain a table where the alignment of the values is lost (for example, value C3 is under the wrong column "sun2" instead the correct column "sun3"):
father sun1 sun2 sun3
A A1 A2 A3
B B1 B3
C C2 C3
Can someone help me?
... View more