Coverting from numeric strings

KrissKdash

Hi

 

I would like covert numeric values into a date. I tried many of sample scripts here but it didn't work.

 

I have 14 digits in a column that should be transformed such as 20200420221043. I want yyyy-mm-ddThh:mm:ss type. Therefore, it seems like 2020-04-20T22:10:43.

 

Any ideas?

gzmorgan0

@KrissKdash ,

 

Just in case you want a column that is a numeric date that is formatted, here is a script to do that. It creates a 1 column table. Extending @txnelson's solution, the string column is called myS. The script creates a date column, myD. The wait(2) is added for dramatic effect. 

 

Just a 2nd approach.

 

Names Default to Here(1);

dt = New Table( "Test",
	Add Rows( 3 ),
	New Column( "myS",
		Character,
		"Nominal",
		Set Values( {"20200420221053", "20200419112025", "20191225055920"} )
	)
);

dt << New Column("myD", Numeric, Continuous);


Column(dt,"myD") << set each value(Informat(substr(:myS,1,8), "YYYYMMDD") + num(Substr(:myS,9,2))*60*60 
            + num(substr(:myS,11,2))*60 + num(substr(:myS,13,2)) );

wait(2);

:myD << Format("yyyy-mm-ddThh:mm:ss", 19, 0);