Jump to content

(Archived) Wired problem with automatic whitespaces - SQL-Scripts


JStarkl

Recommended Posts

Hello

 

I use Evernote for SQL-Scripts a lot, but there is the problem that whitespaces are inserted everywhere in the code, is there a possibility to turn this off?

 

Example:

 

 

Original script:

select top(10)
que.text,
(qst.total_physical_reads/qst.execution_count) as avg_reads,
last_physical_reads as last_reads,
qst.execution_count
from sys.dm_exec_query_stats as qst
cross apply sys.dm_exec_sql_text (qst.sql_handle) as que
order by qst.total_physical_reads/qst.execution_count desc

 

After evernote "parsed" it - via copy & paste to evernote:

select top ( 10)
que .text ,
( qst. total_physical_reads /qst . execution_count) as avg_reads ,
last_physical_reads as last_reads,
qst .execution_count
from sys . dm_exec_query_stats as qst
cross apply sys. dm_exec_sql_text (qst . sql_handle) as que
order by qst. total_physical_reads /qst . execution_count desc


kind regards

Jürgen
 

Link to post
  • Level 5*

You could try paste-as-text (Ctrl+Shift+V) when you paste these into Evernote. Might also be something in the clip source; I use a tool called Clipboard Format Spy to help diagnose these kinds of problems. At the very least, this sort of input is good for the devs to get.

Link to post

I use Ctrl+Shift+V

 

Thanks for the input with the tool: Is seems, the RTF appends a space after each \... - Tag and Evernote identifies this as whitespace, while inserting to MS Word gives the correct result

 

20fsupz.png

 

kind regards

Jürgen

Link to post
  • Level 5*

I'd need to read the RTF standard to know what the correct behavior is. Although every post is read by Evernote staff, if you really want to know about this scenario, you could open a support request for it.

Link to post

Archived

This topic is now archived and is closed to further replies.

Guest
This topic is now closed to further replies.
×
×
  • Create New...