Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting to Excel
Message
From
11/10/2021 17:28:00
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
11/10/2021 17:07:31
Thomas Ganss
Main Trend
Frankfurt, Germany
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Exporting to Excel
Miscellaneous
Thread ID:
01682467
Message ID:
01682482
Views:
32
Yes, it is a double quote.

The version I have presently is :

CHAR(34)+REPLACE(Table.Field,'"','')+CHR(34), in which I just remove the double quote so the delimiters would work. For that content, the double quote was only used to encapsulate long path+file name, which is not needed in Excel. I just wanted to include the log in there as well just to provide more information. The rest of the fields being exported are regular fields, such as Numeric and Integer.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform