476713_en-US

liliconcom

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

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

Data TableRe: Search and Replace on " " (Space) does not work

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

After pressing Replace, the space will be removed

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

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.