Copying and pasting data from the data table to email

[#1]

Hey everyone,

When trying to copy data from a data table and pasting into an email, JMP will not respect the columns on pasting vs if you copy and paste from excel it will respect the columns.  So my work around is to save the data table to an excel table, copy and paste it into the email, then close the excel file.  Beyond annoying.  I'm hoping that I am missing something obvious as a better way to perform this task.

Here is an example of excel (top) vs JMP(bottom) when pasting data from Big Class into an email

The more that the values in the columns are of different lengths, the worse this gets.

Thanks for any ideas!

Steve

[#2]

Hi @shampton82 ,

I think this might be caused by  the changes to Outlook, it used to be you could go on any office application (like you still can with Word) and go "Paste Special> Unformatted Unicode Text" and it would put out the table formatted as you would like - from the looks of it the reason Excel works is because Microsoft already knows it has come from excel 

"Text has its own formatting — such as typeface, color, and font size. When you copy text into a Microsoft 365 app, the app automatically reformats that text to match the text of the destination. However, you can use Paste Special to maintain the original formatting or to paste it as a picture or a link"

Thanks,

Ben

[#3]

Hey @Ben_BarrIngh !

thanks for the reply, I tried your method and I am still getting messed up data when I try pasting, here is an example with trying the method you mentioned:

JMP on the top, excel on the bottom

I'm wondering if I need to make a script that saves the copied data to excel so I can press one button, have the excel data pop up, and then I can copy it more easily and close the excel sheet.  Still pretty annoying but a little more streamlined.  Not sure if there is something I could put in as a wish list.

Steve

[#4]

Hey Steve --

How about journaling  the data table or portion of the data table first? Then you can "paste as image." Not ideal if you're hoping for usable text data, but good for alignment.

[#5]

Not sure if TableBox could be used to "bypass" JMP table

Names Default To Here(1);
rep = Current Data Table() << get as report;
rep = rep[TableBox(1)] << Copy Table;

This could of course be improved to take into account selected rows and columns

[#6]

Hi @shampton82 ,

I think Wish Listing it would be the best shout, then it can come to the attention of the development team and they may find a fix for it.

Thanks,

Ben