Hi Peter,

SURRY, I missed the last lines of yuor message.

I'm fine, but I can see that you are struggling......



>>Hi Peter,
>>
>>You could check each set of data and see if it contains an (.). If not then it's an integer.
>>
>>
>>
>>>Here´s the scenario:
>>>
>>>Reading a CSV/TXT file, I receive "1000","2.541","2000","2000.00"
>>>
>>>The rule says if the value of the string is a true integer (2000), divide it by 100, otherwise (2000.00) leave it as it is.
>>>
>>>Since VFP evaluates 1=1.000 to true, a simple ? INT(VAL(lcValue))=VAL(lcValue) is not very helpful.
>>>
>>>I´ve come up with
>>>
>>>lnValue=IIF("." $ lcValue,VAL(lcValue),VAL(lcValue)/100)
>>>
>>>Which works, of course, except it´s sooo sloooow!
>>>
>>>If there is a better (much much faster) way please let me know!
>>>
>>>TIA
>
>Yes, Benn, I´d thought I´d indicated that that´s what I´m doing.
>Am I missing someting here?
>
>And how are you, by the way?
>
>Cetin: I dont see how loading the stuff into a cursor would help, since one, unless I´m very much mistaken, has to ask the exact same question in one form or another. In addition to that you´d have to walz through the file, non?
>
>There´s gotta be a better way.