SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Can we configure the Excel export not to convert underscores

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Can we configure the Excel export not to convert underscores
Author Message
SqlExplorer



Joined: 18 Sep 2011
Posts: 124
Country: United States

Post Can we configure the Excel export not to convert underscores Reply with quote
Hi,

How do we delete this message? It no longer applies, since it was regarding version 12.

13 might have the same problem, but I want to spend time exploring it, before asking about it.
Mon Jan 06, 2025 1:47 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
It cannot be customized in Export to Excel, it's a feature designed based on users asking.
An alternative is saving results to a CSV file using Save As... menu and then opening that CSV file in Excel. The CSV file is going to have original column names as returned by the database query.
Tue Jan 07, 2025 2:28 am View user's profile Send private message
SqlExplorer



Joined: 18 Sep 2011
Posts: 124
Country: United States

Post Reply with quote
Ok, it's understandable why users would want this to be the default setting. Although it's unusual that they would specifically choose to have no options.

Anyway, thanks, I'll work with it. I can do a quick search & replace, or write a vbscript that converts the spaces to underscores.


SysOp wrote:
It cannot be customized in Export to Excel, it's a feature designed based on users asking.
An alternative is saving results to a CSV file using Save As... menu and then opening that CSV file in Excel. The CSV file is going to have original column names as returned by the database query.

Tue Jan 07, 2025 10:06 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.