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
If it's not broken, fix it until it is.
My Blog