Search and Replace on " " (Space) does not work

[#1]

Hi,

Objective: I would like to cleanup Column names before export into graph database.  The import prices into the graph database would be much easier if I remove the spaces in the column names.  If I go to edit>Search>Find.  In the dialog box I enter a single space character into "Find What:" and clear the text in the "Replace With:" restrict to column names.  It finds nothing and replaces nothing.  Shouldn't this work?

Andy

[#2 · Accepted solution]

For me it seems to be working fine, using JMP16.2.0 Pro on Windows 10.

After pressing Replace, the space will be removed

Edit:

If you are willing to use scripting, you could use something like this (requires JMP16 due to For Each), but of course it would be good to figure out why Find and replace isn't working.

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Iris.jmp");
//dt = Current Data Table();

For Each({col_name}, dt << Get Column Names("String"),
	Column(dt, col_name) << Set Name(Substitute(col_name, " ", ""));
);

[#3]

I think I figured out what was going on.

Previously I must have done a search with multiple spaces and when I entered a single space it pulled that previous search term. Notice the extra highlight on those spaces.  When I deleted them out it worked as expected.