>>>>Hi All:
>>>>
>>>>I have a table with a character field. I COPY it to an XLS. In the case that the data in the field is numeric, I want the data to be numeric in the XLS file. Right now it comews across as text since it came from a character field. The field must be character, since it sometimes contains data that is not numeric.
>>>>
>>>>Any ideas?
>>>>
>>>>Thanks,
>>>>
>>>>Yossi
>>>
>>>I'm not sure you can have different formats in the same column. It may be either numeric or character, AFAIK.
>
>Actually, that is not a problem, since for a given COPY, they will all be numeric, so I envisage something like:
>
>
>COPY fields Numericify(CharField1) TO ("c:\junk\junk") xls
>
>
>CharField1is a character field
Why don't you just select out the data you want and in the select statement convert it to numbers.
SELECT VAL(charfield1) AS numfield1 WHERE ISDIGIT(charfield1) INTO CURSOR ac_numbers
COPY FIELDS numfield1 TO c:\junk\junk.xls TYPE XLS
USE IN ac_numbers
I assume you already know what the where statement should be to filter down the results
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers