QRY : I want to transform string to number ?

[peteh@xxxxxxxxxxxxxxxx (Pete Hall)]

In message <199708200936.LAA11456@mailimailo.univ-rennes1.fr>, From 
Remi.Chapdelaine@univ-rennes1.fr (CHAPDELAINE Rémi), the following was
written: > In some files I have fields in string format, but there are
numbers  > inside (I cannot change these file because they are part of a
product) > I would like to extract informations from these fields, but
get it  > into decimal format (to send them to Excel in the proper
format, for  > example)

Remi,

Is this a positional (fixed length) record? If so, you could easily add
field delimiters (tabs for instance). Excel works well with that. You
can use FTP to do the file transfer, since everything gets converted
EBCDIC-ASCII.

Pete


--
 - Pete Hall peteh@earth.inwave.com
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---