nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Regarding change in data format

kaushik_pushpen

Hello All,

I have a lot table with a date column in which date are mentioned in two different format like 10/27/2016 & 27-10-2016. I want to put them on another column with a single format to plot the variability chart.

Your suggestion will be helpful.

Pushpendra

Accepted answers

kaushik_pushpen

I have again attached the table.

Please confirm me.

table.jmp

All comments

txnelson

Here is a script that will work for you

Names Default To Here( 1 );
dt = Current Data Table();

// Assuming the date column to be read is called "Text Date" the following will work
dt << New Column( "Date",
	Format( m / d / y ),
	formula(
		If( Contains( :Text Date, "-" ),
			Informat( :Text Date, "dd/mm/yyyy" ),
			Informat( :Text Date, "mm/dd/yyyy" )
		)
	)
);

kaushik_pushpen

Hello Jim,

Thank you for the solution.

I have tried your scrip but didn't get the resuls.

I have attached my table into which operation will be performed.

Could you please try your script on this table.

table.jmp

txnelson

I can not find your attached table

kaushik_pushpen

I have again attached the table.

Please confirm me.

table.jmp