>>>Howdy all,
>>>
>>>Trying to take a character field and convert and then calculate against it. It's initially imported as a text delimited field:
>>>
>>>the data looks like: 23.34 or 35.87 etc...
>>>The data field is a character field.
>>>
>>>But when I attempt to perform a calculation, via val(stock_high) - val(stock-low), i receive the function argument invalid count (etc) error.
>>
>>Alltrim() the entries before converting to numeric.
>>
>>? vartype(" 23.42" && C
>>
>>Hank
>
>Hank, vartype() with double quotes always will return C.
>
>? vartype(" 23.42")
>? vartype("23.42 ")
>? vartype("23.42")
>
Oops: brain fart. ;)