[Solved] Cannot remove extraneous white space inside brackets

3 Posts
2 Users
0 Reactions
928 Views
Posts: 3
Topic starter
(@agwillow)
Member
Joined: 2 years ago
[#116]

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.


2 Replies
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

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.


Reply
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

@agwillow,

there is a new option which should do the trick.

grafik

 


Reply
Share: