Data is coming from a query.
I can query select part, trim(part), or ltrim(rtrim(part)).
whatever I do, the report makes the column show up with spaces like:
Which then makes the column appear incorrectly in the column.
8.1.42
I have tried:
Making new queries
Making new column names
Various trim techniques
Updating the table to set to the trimmed output
Changing fonts and text size
Not sure what to try to fix it.
If I type in Test@Part@ for the column in the report table,then result is TES12345 without spacing, which is kind of frustrating, but maybe can help me fix it.
set Part = LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(Part, CHAR(10), CHAR(32)),CHAR(13), CHAR(32)),CHAR(160), CHAR(32)),CHAR(9),CHAR(32))))
My data got contaminated with some kind of invisible character it seems. I was able to replace the hidden character with the above in sql.
I'd be inclined to figure out what's wrong with the data. Replace each of the control characters, one at a time, with an * to see what they are. Then fix the data. Otherwise it's likely to bite again.
2 Likes
The strings were imported with the invisible character(s) from excel.
I am sure this will come up again, the character is invisible from source, export, or excel.
Trying to clean it before this afternoon.
I think it did happen to me before, after you mentioned it, I vaguely recall a year ago maybe.