Remove trailing spaces
Option to remove trailing spaces from script lines. This can be done via search/replace functionality but it would be nice to have this taken care of automatically during the SQL code reformatting
![](https://secure.gravatar.com/avatar/5dd6d7b3755adb45faeb5b7236aca82d?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
Version 8 of SQL Prompt allows you to do this as part of its new formatting system.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If there is something missing please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
Richard commented
@Tuomo... You say that it does this; but it doesn't do that for me. I'm using 7.0.0.62, and it doesn't remove tabs or spaces on an otherwise blank line; and it doesn't remove similar trailing whitespace on other lines in the script. I can't spot any options in and of the "SQL Prompt"/Options/Format sections.
-
Rubiksmomo commented
"SQL Prompt > Format SQL" does this in current version
-
Jim commented
Not only spaces, but white space in general, like tabs too.