Add a character to each row in a JMP column

[#1]

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

[#2 · Accepted solution]

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

[#3 · Accepted solution]

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.

[#4 · Accepted solution]

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