Hi Naomi,
I don't see how that applies in this case. Could you explain, please?
>See this neat old trick for the alternative solution.
>
>
Re: Blank address lines Thread #
959791 Message #
959963>
>>Hi Tariq,
>>
>>use the IIF() function to determine if to add the comma or not.
>>
>>Something like this (off the top of my head):
>>
>>alltrim(fld1) + IIF(EMPTY(fld1), "", ",") ;
>>+ alltrim(fld2) + IIF(EMPTY(fld2), "", ",") ;
>>+ alltrim(fld3) + IIF(EMPTY(fld3), "", ",") ;
>>+ alltrim(fld4) + IIF(EMPTY(fld4), "", ",") ;
>>+ alltrim(fld5)
>>
>>
>>>Dear Experts
>>>
>>>Table1 has 5 fields as
>>>
>>>fld1--c(10)
>>>fld2--c(10)
>>>fld3--c(10)
>>>fld4--c(10)
>>>fld5--c(10)
>>>
>>>There is only one record in dbf as
>>>fld1="a"
>>>fld2="b"
>>>fld3=""
>>>fld4=""
>>>fld5="e"
>>>
>>>The data may be vary type,for example
>>>sometimes all fields are filled
>>>sometimes some fields are filled
>>>sometimes all fields are empty
>>>
>>>When I use as
>>>alltrim(fld1)+alltrim(",")+alltrim(fld2)+alltrim(",")+alltrim(fld3)+;
>>>alltrim(",")+alltrim(fld4)+alltrim(",")+alltrim(fld5)
>>>
>>>then It show extra comma when some field is empty as
>>>a,b,,,e
>>>
>>>In report, I want to show data in only one field as
>>>a,b,e
>>>
>>>The filled data should print side by side with comma separation.
>>>
>>>Please help