cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

Ctrl+F - find and replace in a formula column

hcarr01
Level VI
Good morning,
I have a very simple question about JMP:
Is it normal not to be able to perform a "Ctrl+F" on a column that has already been recoded with a formula? And how do you find a solution?
 
THANKS.

 

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .

1 ACCEPTED SOLUTION

Accepted Solutions
Craige_Hales
Super User


Re: Ctrl+F

Find should work.

Modify should NOT work. A formula column's values can't be changed. You can remove the formula by clearing the expression in the formula editor. The last values from the formula remain in the column. Then find/replace will work.

Craige

View solution in original post

3 REPLIES 3
Victor_G
Super User

Re: CTRL+F

Good morning @hcarr01 ,

 

Normally you can always search for an element or a value of a column with "CTRL+F", whether the column is selected or not. It is just necessary that the data table on which you are doing the search is in the "foreground".
Keyboard shortcuts : Windows and macOS Keyboard Shortcuts (jmp.com)
After pressing "CTRL+F", this window is displayed:

 

undefined

 

If you can provide more details, screenshots possibly showing the problem, or other things that can focus and guide the discussion, it might help other members of the community to give you advice.

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .

hcarr01
Level VI

Re: CTRL+F

Thank you for your reply,
I may not have been specific enough, I meant that on a column recoded by a formula, I cannot use the "Ctrl+F" query to find and modify values in that specific column.

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .

Craige_Hales
Super User


Re: Ctrl+F

Find should work.

Modify should NOT work. A formula column's values can't be changed. You can remove the formula by clearing the expression in the formula editor. The last values from the formula remain in the column. Then find/replace will work.

Craige