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