topic Re: JMP Scripting Collapsing Whitespace in All Columns in Discussions

JMP Scripting Collapsing Whitespace in All Columns

dn610 — Fri, 09 Jun 2023 18:14:43 GMT

Is there an easy way to collapse whitespace in all the columns using JMP Scripting?

Re: JMP Scripting Collapsing Whitespace in All Columns

ErraticAttack — Tue, 29 Mar 2022 20:41:17 GMT

Try sending the message <<Optimize Display, as shown in the Scripting Index

Re: JMP Scripting Collapsing Whitespace in All Columns

txnelson — Tue, 29 Mar 2022 20:56:08 GMT

If you want to do this interactively,

Select all of the columns you want to change width on
Hold down the Shift and ALT keys
Go to the edge border of one of the columns you have selected, and click and drag the column width to the width you want. All of the selected columns will expand or contract to your specified width

Re: JMP Scripting Collapsing Whitespace in All Columns

Joseph_Reese — Tue, 29 Mar 2022 21:06:16 GMT

Hello, just in case you are asking about performing a Collapse Whitespace function on every character column to remove excess whitespaces there is a script below. I am sure there are many ways to do this but I just stole some code from the advanced log after manually recoding a column. Wasn't sure exactly what you were asking for so thought I would provide this just in case.

Names Default to Here(1);

dt = Current Data Table();

Cols = dt << Get Column Names( Character, String);

For(
	i = 1, i <= N Items( Cols ), i++,
	
	Eval(
		Eval Expr(
	
			dt << Begin Data Update;
			dt << Recode Column(
			Expr( Column( dt,  Cols[i] ) ),
			{Collapse Whitespace( _rcNow )},
			Update Properties( 1 ),
			Target Column( Column( dt, Expr( Cols[i] ) ) )
			
		)
		
	)

	
);

dt << End Data Update;
	
)

Re: JMP Scripting Collapsing Whitespace in All Columns

dn610 — Wed, 30 Mar 2022 13:04:29 GMT

This is exactly what I'm looking for, but it didn't work for me. I got the error message below when I tried the script.

Re: JMP Scripting Collapsing Whitespace in All Columns

dn610 — Wed, 30 Mar 2022 15:52:06 GMT

I tweaked it, and it now works. Thank you!

Re: JMP Scripting Collapsing Whitespace in All Columns

Joseph_Reese — Wed, 30 Mar 2022 15:53:53 GMT

@dn610 You may not be using JMP 16. I have noticed that when using the Recode script, in version 16 that line for Update Properties gets added. If you just delete that line for update properties the code should still work for earlier versions.

Re: JMP Scripting Collapsing Whitespace in All Columns

dn610 — Wed, 30 Mar 2022 17:06:49 GMT

I'm using JMP 15, and that's exactly what I did to make it work. Thanks again!