Different spacing around commas for lists

2 Posts
2 Users
0 Reactions
306 Views
(@lamprey)
Member
Joined: 2 years ago
Posts: 8
Topic starter  

Hi,

I’ve been able to get most of the formatting the way I want. But, there are two things that ae in conflict with the current configuration options. As far as I can tell there is only one White Space setting dealing with commas. It would be nice if there were two settings, an additional one for Lists.

Currently, I have the white space “around commas” set to Once Space After and that works great for general formatting when dealing with functions. In this example it puts one space after the commas:

string_agg(convert(nvarchar(max), foo_id), N'; ') within group (order by foo_id) as foo_id_list

 

But, when it comes to Lists (like a select list) it also put a space after the comma. For example:

select
	foo
	, foo1
	, foo2

My request is to keep the white space setting as is for “non-list” items and add a new option for lists (select, group by, etc.). So, for example the select list could be like:

select
	foo
	,foo1
	,foo2

I realize it’s not too hard to fix this up post-format, but it would be a nice option.

Thanks!

 

 


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

Hi Lamprey, thanks for this idea. I have to think about how to introduce this idea without confusing users with too many options.

Give me some time please

Regards

Guido


   
ReplyQuote
Share: