topic Re: Substituting a space for underscore in a character string in Discussions

Substituting a space for underscore in a character string

RandomMapsFox62 — Thu, 08 Jun 2023 16:38:33 GMT

Hi:

I have a long description of a product that includes a bunch of underscores __ which I don't want. I'd like to replace them with spaces instead.

I've tried using substr(substitute(columnname, "_",""),1, 999) but that just makes the entire field blank.
I've also tried the reverse (substitute(substr....) same problem.

Help!

JMP 17 FWIW.

Re: Substituting a space for underscore in a character string

jthi — Sat, 04 Feb 2023 19:02:11 GMT

Just using Substitute should be enough (or Substitute Into() depending on what you are doing)

Names Default To Here(1);

str = "aaa________b_c_________________d";
new_str = Substitute(str, "_", " "); // "aaa        b c                 d"

Re: Substituting a space for underscore in a character string

brady_brady — Mon, 06 Feb 2023 19:43:59 GMT

Hi, notice that Jarmo's code replaces the underscores with a space character, " ", while your code replaced the underscores with the empty string, "", which was at least part of the problem.