This could be isaue with mid tier as well.
Can you please confirm if this happens in user tool as well.
yes Sidhdesh. It happens in user tool as well
I wrote an SQL Server Function a few years ago at a job that parsed the values in a diary and turned them into human readable HTML....it wasn't hard to write...you just need to use some simple string parsing commands at the DB and iterate through the results till you get what you need....get coding