Substituting a space for underscore in a character string
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.