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

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

< 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>