moving column named via string variable to after another column also named via string variable

galactus3000

How do I  move a column referenced by a string variable to after another column also referenced by a string variable in table st

 

zzz = Column(cnm);
colst = {zzz};
Eval(Eval Expr(Expr(st<<MoveSelectedColumns(colst, After(yyy)))));

 

my Locals show that

Variable cnm has the Value "ppg 1000" of type String

Variable yyy has the Value Column("lxt 1000") of type Column

Variable zzz has the Value Column("ppg 1000") of type Column

Variable colst has the Value {zzz} of type List

 

Thought I would need to use Eval, Eval Expr, Expr, etc to get this to work, but cannot seem to get it right.

Please help.  Thanks in advance.

 

Cheers

Galactus3000

 

 

pmroz

Here's another way that builds a string dynamically and then executes it via eval(parse()).  

 

st = New Table( "Untitled", Add Rows( 2 ),
	New Column( "lxt 1000", Character, "Nominal", Set Values( {"a", "b"} ) ),
	New Column( "Column 2", Numeric, "Continuous", Format( "Best", 12 ),
		Set Values( [1, 2] )
	),
	New Column( "ppg 1000", Numeric, "Continuous", Format( "Best", 12 ),
		Set Values( [3, 4] )
	)
);

wait(2);
cnm = "ppg 1000";
yyy = "lxt 1000";

move_expr = evalinsert("\[st << Move Selected Columns({"^cnm^"}, After("^yyy^"))]\");
eval(parse(move_expr));