I have an XML file generated from sql queries, one issue what I have here is when I try to open that particualr xml file using textpad, notepad++, wordpad or notepad the data is all jumbled. Its not formatted properly, the file tree structure is actually
correct with correct data in there which looks good when I open it using Internet explorer.
The file that I generate gets printed in dialy news paper so there would be some last minute corrections within the file which are done manually opening the file using any of the above listed tools. What I need here a properly formatted file when opened
in any of the text editor tools.
I read about the Carriage Return and new line characters which we have in sql server but donno how they can help me, would be greatful if somebody guide me. (i.e) Char(13) & Char(10) are the new for newline and carriage return codes
View Complete Post