News
On June 1, we’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Highlighted
Maureen
Level I

pasting bug?

I am having a very difficult time lately copying and pasting from excel (Excel for Macintosh version 16.12) to JMP (13.2.0).

A column of numbers (not dates or text) will want to paste as characters.  When I accept that and then go into Standardize attributes and recode I can always find one single value that has gibberish characters added to the number.

This can even happen if I take a numerical column of data, paste it into Excel and immediately back into JMP - junk characters are added that are invisible in Excel (Excel treats the data as numbers).

Anyone know of a fix for this?

0 Kudos
7 REPLIES 7
Highlighted
gzmorgan0
Super User

Re: pasting bug?

I don't have a MAC so here are 3 suggestions:

  1. Format the numeric columns as Numeric
  2. Use the Excel Clean function  =Numbervalue(Clean(A1))  that removes unprintable characters.
  3. Use Open > Excel Wizard. A column with unprintable characters in Excel (line feedd and tables and leading and trailing spaces) did not paste correctly into JMP.  However, when I opened that same file using the Excel Wizard all the junk was removed. 

Neither method is easy if you have numerous columns. But I'd suggest you copy and paste into a new sheet.

 

Then use the JMP Excel Wizard and only select that sheet.  In JMP 13, I have seen that the Excel wizard has some problems with columns with formulas, so make sure the columns have values.  [JMP 14 does not have this issue].

 

Good Luck! 

Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: pasting bug?

Without seeing the original Excel file this will likely be difficult to diagnose. If you can't post a sanitized version here, contact Tech Support and send them the file. They can probably explain what's happening and give strategies (perhaps like @gzmorgan0's above) that will help.

-Jeff
0 Kudos
Maureen
Level I

Re: pasting bug?

It's always different files.  A clarification from my first post is that I can take a column of numbers from JMP, paste them into Excel and then immediately paste them back into JMP and have it happen.

It usually happens in the last column of data copied over.

Here is a screenshot of one from today.

Screen Shot 2018-08-15 at 10.03.21 AM.png

0 Kudos
Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: pasting bug?

That is odd. I've tried to replicate the problem here but haven't been able to. I do notice that I have Excel 16.16. Is it possible for you to make sure you've got the latest release of Excel?

-Jeff
0 Kudos
Highlighted
gzmorgan0
Super User

Re: pasting bug?

This is a sidebar to your issue. Might I ask what you are trying to do?

 

Were you copying from JMP to Excel then back again, only to create a good test case, or was this what you were doing when you found the problem?

 

The reason I am asking is because I have seen newer JMP users do this to use Excel's filters and/or stacking and/or formulas. I do not wish to offend, I am just asking. 

 

If your task is to just copy from Excel to JMP, please ignore my question. 

 

Highlighted
Maureen
Level I

Re: pasting bug?

I go back and forth between JMP and Excel all the time.  I can do basic formulas in JMP, but for logical formulas and a few other things I am much more familiar with Excel.  All my statistics are JMP, but I do clean and organize data in Excel just because it's easier for me.

0 Kudos
Highlighted
gzmorgan0
Super User

Re: pasting bug?

I would encourage you to learn a few more JMP functions and table features. I have numerous experiences where Excel devotees were using JMP for the statistics and graphics and using Excel to do some data cleaning. And after a few hints, they gave up the copy and paste back and forth with Excel. 

Here is a 30 minute video, you might find useful, it is titled Letting Go of Excel

https://community.jmp.com/t5/video/gallerypage/video-id/xqbW40ODE6WV5ISTJ_ASyNfZRb4i0NVv

 

Below is a "reading list" if you are interested in leraning more.

Good Luck!

 

Note Help>Scripting Index will show you JSL synatx for things that you can do in the formula editor. Even if you are not interested in scripting, this is an easy method to learn what a function does.  Help>Scripting Index > Functions 

  •  Conditional functions:   If() ,  Match(),  Choose(),  And(),  Or() , IsMissing()
  •  Character functions: Concat(), Substr(), Starts With(), End With(), Trim(), Char(), Num(), Lenght(), Word() You will be surprised how useful Word() can be for pulling items from string.
  • Numeric, Transcendental, Trignometric 
  • Statistical

Help>Scripting Index > Objects > Data Table

  • Search for Stack, Split, Subset

 Learn how to use Row> Select > Select Where with Add condition...very useful