[Stackoverflow] [Progress OpenEdge ABL] Is it possible to convert CHARACTER to INT

Not open for further replies.

Jack Williams

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...
Not open for further replies.