End Of Record

[cobweb]

Hello There:
I have an XML file that I am trying to convert to a database format.
I have played about with an XSLT but cannot find an instruction for 'end of record'.
THe XML is a series of purchase orders so I need to separately define each order. I am initially looking to convert to text but the result does not delineate between each record; giving instead a long string divided by semi colons. The order is defined under the first element JOB and all element under that define the lines of the order; but how can I put an 'end of line' or 'end of record' command in after each JOB; and how can I put a comma between each element to get a csv format?

Thanks!

 

[cobweb]

Follow up to the above:

I have now got a long string of elements, comma separated.
All I need is to put a line break after each Job Number.

I am creating 2 csv files; the header comprises the elemnts of Job, JobNumber and customer.
It is the detail file that needs the JobNumber (for the database to join to the header) and the elements that comprise the materials for the job.
I am a real newbie to this and the JobNumber is at a level above the materials; it has taken me this long to get the number on the same line as the materials - but now it is one very long line!

Thanks in anticipation!