topic Re: How can replace a specified literal with a newline or TAB with a regular substitution method? in Discussions

How can replace a specified literal with a newline or TAB with a regular substitution method?

lala — Wed, 22 Apr 2020 10:16:21 GMT

a="AB</>CDEFG<->HIJK</>LMNOP<->QRSTU</>VWXYZ"

Regular methods are not used.
Replace </> with a TAB.
Replace <-> with a newline character.

This writes the contents of a to the table.Thanks!

Re: How can replace a specified literal with a newline or TAB with a regular substitution method?

pmroz — Wed, 22 Apr 2020 11:31:44 GMT

In JMP you can specify a newline and tab like this:

newline = "\!n";
tab = "\!t";
a = evalinsert("Hello World^tab^Again^newline^Fubar^tab^Again");

Use the substitute command to replace your character strings with newline or tab.

newline = "\!n";
tab = "\!t";

a = "AB</>CDEFG<->HIJK</>LMNOP<->QRSTU</>VWXYZ";
b = substitute(a, "</>", tab);
c = substitute(b, "<->", newline);

write(c);

Output:

AB	CDEFG
HIJK	LMNOP
QRSTU	VWXYZ

Re: How can replace a specified literal with a newline or TAB with a regular substitution method?

Stefan — Thu, 28 Jan 2021 15:54:36 GMT

@pmroz thank you...do you have any idea on how to do this when sending an email via the mail() function?

Cheers!