How to rename multiple variables from 1 column?

Azim

I have multiple variables in 1 column (i.e., B,F,T) which needed to be renamed. 

Local({dt, col1},
	dt = Data Table("ProductDefect");
	dt << Begin Data Update;
	col1 = dt << New Column(dt:LayerData);
	col1 << Set Name("Side");
	dt << Move Selected Columns({col1}, after(dt:LayerData));
	For Each Row(
		dt,
		col1[] = If(Contains(dt:LayerData, "B"),
			"Back",
			dt:LayerData
		)
	);
	dt << End Data Update;
);

Using this script, I am only changing for B while the other variable (i.e., "F","T") will not be changed. What should be done for all to be renamed in new column; B = Back, F = Front, T = Top?

jthi

You can use Recode and Replace string multiple times. I don't know your data, so I'm not sure what would be the best way (I would maybe go with simple regex and if more complicated is necessary you could also do that)

Repeat this for all with their own patterns

And JMP creates you a script

// Recode column: ProductDefect
Local({dt},
	dt = Data Table("Sheet1");
	dt << Begin Data Update;
	dt << Recode Column(
		dt:ProductDefect,
		{Regex(_rcNow, ".*?\d+B.*", "Back", GLOBALREPLACE),
		Regex(_rcNow, ".*?\d+T.*", "Top", GLOBALREPLACE),
		Regex(_rcNow, ".*?\d+F.*", "Front", GLOBALREPLACE)},
		Update Properties(1),
		Target Column(:ProductDefect)
	);
	dt << End Data Update;
);

If you don't want to do it in place,run recode without that enabled