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

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

Similar threads

U
  • Locked
[Stackoverflow] [Progress OpenEdge ABL] 3rd-party tool for analysis converts its report to the Generic Issues format in sonarcloud
Replies
0
Views
61
user22389296
U
L
  • Locked
[Stackoverflow] [Progress OpenEdge ABL] Is it possible to connect to Progress DB if you don't know any login info?
Replies
0
Views
86
lemming3k
L
B
  • Locked
[Stackoverflow] [Progress OpenEdge ABL] OpenEdge ABL JSON to temp table: READ-JSON
Replies
0
Views
352
BobNoobGuy
B
T
  • Locked
[Stackoverflow] [Progress OpenEdge ABL] Progress 4GL - How to convert data from UTF-8 to UTF-8 BOM?
Replies
0
Views
409
Thiru
T
T
  • Locked
[Stackoverflow] [Progress OpenEdge ABL] How to export the start date and time in MS Project?
Replies
0
Views
109
time pass
T
Top