topic Re: Add a character to each row in a JMP column in Discussions

Add a character to each row in a JMP column

SpannerHead — Tue, 20 May 2025 20:11:09 GMT

I have a JMP column with data where I would like to systematically add the same initial character to each entry.

Re: Add a character to each row in a JMP column

txnelson — Tue, 20 May 2025 20:46:57 GMT

Given a character column with the name "mycol" here is a script that will add the character "A" as the first character to the mycol column for each row

for each row(
     :mycol = "A" || :mycol;
);

Re: Add a character to each row in a JMP column

Craige_Hales — Tue, 20 May 2025 22:01:21 GMT

If you are comfortable with regex, you can use find/replace to do it; .* matches the content of each cell and \0 refers to the entire match.

(view in My Videos)

Re: Add a character to each row in a JMP column

jthi — Wed, 21 May 2025 05:51:47 GMT

Recode can also be used for this with Replace String

You can also do this by using new formula column and replace data in place