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

Hegedus1

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

jthi

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, " ", ""));
);