Skip to Content
0
Former Member
Jul 15, 2008 at 10:47 PM

Underscores in report results ie: "__B"

56 Views

Seems like something easy, but I have a web app and when I write and use a simple standard report, extracting data with the Microsoft SQL ODBC driver, I get data like "Los__bAngeles" or "New__BYork", etc.... How do I get the data out so that I get spaces, apostrophies, etc to show properly? Is there a formating option? I have tried the Format Field -> Text Interpretation -> HTML text. This does not seem to make any difference. Thx