Overwrite data in a table

[#1]

Hi, 

I am trying to clean up my data table. I have a table with some value which are "x", "X", "X-Direction", "X-direction", but they are all the same, which is "X". 

How can I change the values (in the script) so it overwrite everything with the same format ("X")?

Because then, I want to split my data table and it gives me 4 columns where I should have only 1... Thanks!

[#2 · Accepted solution]

One option is to use Recode:

Select your values you wish to recode

Press Group

Select how you wish to recode them

And finally press Recode

Changed this:

to this

And if you have JMP16+ you can get the code from action recorder

// Recode column: Column 6
Local({dt},
	dt = Data Table("Big Class");
	dt << Begin Data Update;
	dt << Recode Column(
		dt:Column 6,
		{Map Value(
			_rcOrig,
			{"X-Direction", "X", "X-direction", "X", "x", "X"},
			Unmatched(_rcNow)
		)},
		Update Properties(1),
		Target Column(:Column 6)
	);
	dt << End Data Update;
);

Or from Recode menu before you press Recode

[#3]

It works!! Thanks :))