[Solved] Cannot remove extraneous white space inside brackets

3 Posts
2 Users
0 Reactions
310 Views
(@agwillow)
Member
Joined: 8 months ago
Posts: 3
Topic starter  

We have SQL that includes unneeded white space within (square) brackets — a side effect of a dynamic SQL-generation process. For example:

SELECT AvailableLaborId = a.[AvailableLaborId       ],
  UserNo = a.[UserNo          ],
  ...
FROM AvailableLabor a
  ...

 Is there some way to have SQLinForm remove it? Under White Spacces [sic], Around Brackets is set to No Spaces, but neither that nor any other setting gets rid of the space within the brackets.


   
Quote
Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 223
 

Thanks for your feedback. Will include this into the next Release. Currently tokens inside squared brackets are not changed in any way.

Current option "Spaces around brackets" is for (round) brackets.


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 223
 

@agwillow,

there is a new option which should do the trick.

grafik

 


   
ReplyQuote
Share: