Post reply

Tab, CHR(9), not working in browser

  • May 13, 2011 at 4:50 am

    #250890

    Hey.

    For some reason the tab ascii character (CHR(9)) is not working when the report is run through internet explorer. However it does work when I view it through visual studio. Does anyway know why this may be and how to rectify it?

    Thanks

    Dave

  • May 13, 2011 at 6:22 am

    #1324233

    browsers ignore whitespace...tabs, CrLf and more than one space in a row; that's part of the html definition

    if you need to visualize whitespace, you'll need to html-ize the results...either by substituting CHAR(160), which is a high ascii for a space that html doesn't ignore, or replaces spaces with the html non breaking space &ampnbsp ;

    personally i'm fond of doing it in the SQL and using REPLACE(ColName,' ',CHAR(160)); a tab/CHAR(9) would typically be four char(160) characters

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply