J
Jack Williams
Guest
I have a dataset which currently the Event Time (trovalue) is in a CHARACTER format. I need to be able to convert these to an INTERGER so i can SUM these on import so i am able to GROUP the data.
Currently i have tried to do the following which is returning an error of invalid number string (7498):
CAST (TemplateRunObject_0.TroValue AS INT)
I am working from a Progress OpenEdge ODBC and pulling directly into Excel.
What is the best way to convert CHARACTER to INTERGER
Continue reading...
Currently i have tried to do the following which is returning an error of invalid number string (7498):
CAST (TemplateRunObject_0.TroValue AS INT)
I am working from a Progress OpenEdge ODBC and pulling directly into Excel.
What is the best way to convert CHARACTER to INTERGER
Continue reading...