>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
lcTest = alltrim(fld1)+","+alltrim(fld2)+","+alltrim(fld3)+","+alltrim(fld4)+","+alltrim(fld5)
DO WHILE ATC([,,],lcTest)
lcTest = STRTRAN(lcTest, [,,],[,])
ENDDO
>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.