topic Re: remove carriage return in Discussions

remove carriage return

ckronig — Fri, 20 Dec 2024 16:00:46 GMT

I am using JMPPro 18. I am trying to develop some scripts to clean up my data, and I have an issue with the carriage returns. I have read other other posts on this subject, and it is still not working for me.

when I use Recode to remove these, it works fine. However, when I save the recode workflow, and run the workflow, the data is not recoded.

I have tried using \r and \!r as suggested in other posts (but I notice that these don't appear in the recode script), but no luck

Any ideas where this is going wrong and what I could try would be most useful! Thanks in advance

Re: remove carriage return

jthi — Fri, 20 Dec 2024 16:40:01 GMT

Try using \!N then \!r , \!n and finally some weird combination of these. If none of these work, you might have to use regex / substitute. You can find JMP's escape sequences from here Scripting Guide > JSL Building Blocks > JSL Syntax Rules

Re: remove carriage return

pmroz — Fri, 20 Dec 2024 17:17:41 GMT

You can also use something like this:

crlf = hex to char("0D0A");
print("CRLF Hello" || crlf || "World");
 
cr = hex to char("0D");
print("CR Hello" || cr || "World");
 
lf = hex to char("0A");
print("LF Hello" || lf || "World");

These snippets produce similar output.

"CRLF Hello
World"
"CR Hello
World"
"LF Hello
World"

Re: remove carriage return

ckronig — Mon, 06 Jan 2025 15:13:47 GMT

Thanks for your response, I used \!n and my script now works! Much appreciated.