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

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

Hegedus1 — Sat, 10 Jun 2023 23:46:51 GMT

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

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

jthi — Wed, 06 Apr 2022 19:10:35 GMT

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

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

Hegedus1 — Wed, 06 Apr 2022 19:27:31 GMT

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.