Text Trimmed Automatically
Answered
I would like to know if text is somehow trimmed by Yellowfin or is it my vendor? When I type the below SQL my report "fixes" the formatting so that there is one space between characters:
SELECT DISTINCT '1 2 3 4',Produces:
For example, I created a CASE statement based on what the report was displaying and that was 'Unknown - discharged due to inactivity' but in the database field it was actually stored as 'Unknown - discharged due to inactivity'. Notice the additional space between '-' and 'discharged'.
The same question
Hi Larry,
looks like it is Yellowfin because when I try a similar thing, but this time with a calc field of Formula Type "Simple" instead of "Freehand SQL" it does the same thing and it definitely didn't go to the database and back yet. I have attached a short video to show this to you ("Neatly_trimmed_textbox.mp4").
regards,
Dave
Hi Larry,
looks like it is Yellowfin because when I try a similar thing, but this time with a calc field of Formula Type "Simple" instead of "Freehand SQL" it does the same thing and it definitely didn't go to the database and back yet. I have attached a short video to show this to you ("Neatly_trimmed_textbox.mp4").
regards,
Dave
I see, it's probably for the better. At least I know now. I tried RAW formatter and I wondered why that wouldn't skip the trim function. No worries, thanks BIG DAVE!
I see, it's probably for the better. At least I know now. I tried RAW formatter and I wondered why that wouldn't skip the trim function. No worries, thanks BIG DAVE!
you're welcome Larry!
you're welcome Larry!
Replies have been locked on this page!