I have a table as following
| Archive id | Line | Author | Time | Text |
| 1fjj34 | 3 | 75jk5l | 03:20 | this is an evidence regarding ... |
| 1fjj34 | 4 | gjhhtrd | 03:21 | we have seen those documents before |
| 1fjj34 | 10 | 645jmdvvb | 04:00 | Will you consider such an offer? |
| 3a530 | 3 | 67rdnsa | 01:17 | Will you consider such an offer? |
but my separators are "|" so my plain text files looks like
Quote:
Archive id|Lie|Author|Time|Text
1fjj34|3|75jk5l|03:20|this is an evidence regarding xxx
1fjj34|4|gjhhtrd|03:21|we have seen those documents before
1fjj34|10|645jmdvvb|04:00|Will you consider such an offer?
3a530|3|67rdnsa|01:17|Will you consider such an offer?
|
I have absolute no ideal when where to start in relation to convert it to XML and my data is nested so bit confused. I would be grateful if you can help me.
the output structure is
Code:
< archives>
…
< archive id="1fjj34">
<file line="3">
<author>75jk5l</author>
<time>03:20</time>
<text> this is an evidence regarding xxx </text>
</file>
<file line="4">
<author>gjhhtrd</author>
<time>03:21</time>
<text> we have seen those documents before </text>
</file>
…
<file line="10">
<author>645jmdvvb</author>
<time>04:00</time>
<text> Will you consider such an offer? </text>
</file>
</archive>
…
< archive id="3a530">
<file line="3">
<author>67rdnsa</author>
<time>01:17</time>
<text> Will you consider such an offer? </text>
</file>
</ archive>
…
< archives>