RE: char to numeric

Lim,

You could try:

D  NUMERIC        S             10  2 INZ(0)
D  CHARACTER      S             10    INZ('1234567.90')

NUMERIC = %DEC(%TRIM(CHARACTER) : 10 : 2);


I don't know what the performance would be, but I do know that it will
convert character to numeric regardless of the trailing blanks. It does
have a problem with dollar signs and commas but not decimal points.



Terry Anderson

message: 10
date: Fri, 2 Mar 2007 10:51:32 -0600
from: "Lim Hock-Chai" <Lim.Hock-Chai@xxxxxxxxxxxxxxx>
subject: char to numeric 

I need to write a process that requires converting a 10 
chars field in a file to a numeric field.  There are 
millions of records in this file and speed is very import 
for this process.  Does any one know of the most speedy way 
to do this conversion?  Note:  This char field is left 
justified (contains tailing blanks) and could contain all blanks.

thanks.