topic Re: JMP copy paste error in Discussions

JMP copy paste error

SharathPS — Sat, 10 Jun 2023 23:56:32 GMT

Hi I am copying a cell containing the text

48-pin ultra-thin fine pitch quad flat package no leads
(UFQFPN)

from excel into JMP. The file is originally a csv file opened in excel.

In JMP it ends up in two rows instead of one cell as:

How can I avoid this. I have already tried formatting excel column as text and setting JMP column to character type.

This happens in lines when there is a bracket (square / parentheses / angled brackets) inside the text. Why is JMP doing this?

Re: JMP copy paste error

Craige_Hales — Sat, 05 Nov 2022 03:00:46 GMT

If you peek at the CSV with a text editor like notepad, is there a new line in the value?

You might be able to work around the problem manually with find/replace after importing the data.

Find what: holds the new line sequence to be replace with T for KATIE.

Depending where the data came from the newline sequence may be CR, LF, or CRLF. Depending on your OS, typing a newline might not match. Worst case, regex might be needed:

Plus means one or more of the set of characters \n (newline) and \r (return).

Try a couple before you hit Replace All. Consider choosing Restrict To Selected Column.

Edit: @SharathPS I suspect I've misunderstood your question. Try double-clicking the cell in the JMP table before pasting. When you double click, you'll see a text edit box and the entire paste will go into that box. Otherwise, when the cell is single-click selected and not showing the edit box, newlines in the paste data will advance to the next cell.

Re: JMP copy paste error

SharathPS — Sat, 05 Nov 2022 22:32:11 GMT

Thanks @Craige_Hales for the response. But, I am copy pasting a huge excel sheet and I cannot apply that to each cell.

However I opened the csv file directly in JMP and the lines don't jumble up when I do that. I then save it as a jmp file.