I have an xml document that I format into a table with an xsl sheet. This works OK, but I have a couple of bit that I can't seem to get.
1. I need to force <br> tags into the output. I have an address in a single cell and need each line of the address to be on different lines.
i.e.
Company Name
Address1
Address2
etc
2. I need to format the output differently from the data stored in XML. The original file has dates stored as dd mmm yyyy. I need the output to use this date and format it as ddmmyy.
3. I need my invoice lines to be alternately coloured.
Is any/all of this possible within my xsl sheet?
1. I need to force <br> tags into the output. I have an address in a single cell and need each line of the address to be on different lines.
i.e.
Company Name
Address1
Address2
etc
2. I need to format the output differently from the data stored in XML. The original file has dates stored as dd mmm yyyy. I need the output to use this date and format it as ddmmyy.
3. I need my invoice lines to be alternately coloured.
Is any/all of this possible within my xsl sheet?