error message
Invalid subscript reference
if inlist(laFields[m.lnI,2],'N','I','B')
>Try
>

>if inlist(laFields[m.lnI,2],'N','I','B') && Numeric, double or Integer
>   replace ...
>endif

>
>>hi,
>>
>>i'm sorry ,
>>i have another type need to convert to null or space ...
>>type double and integer.
>>
>>thanks
>>
>>>If this is the case, you should make them NULL, not blank, AFAIK.
>>>
>>>Change the command to
>>>replace (laFields[lnI,1]) with NULL for empty(&laFields[lnI,1])
>>>
>>>Check Re: Blank dates in Excel Thread #1140736 Message #1142863
>>>
>>>>yes,
>>>>i convert this table to excel sheet, i found many records have zeroze...
>>>>
>>>>>You cannot fill space to numeric field. Maybe you want to show blank on screen when table field value is zero?
>>>>>