>
>DET-A|JOHN DOE |INFO1
>DET-B|1234 5TH ST |INFO2
>DET-C|APT. 3 |INFO3
>DET-D|ANYWHERE, IA 12345 |
>DET-E|(123) 456-7890 |
>DET-F|JOHNDOE@HOTMAIL.COM |
>
>
>The problem now is that if the 2nd address line is not available, the section would still be displayed because INFO3 might not be blank. Is there an easy way to handle this, or do I need to re-think the report design?FOR I = 6 TO 1 STEP -1 IF EMPTY(myArray[i]) =ADEL(myArray,i) ENDIF ENDFORwhich yields
BEFORE AFTER JOHN DOE JOHN DOE 1234 5TH ST 1234 5TH ST ANYWHERE, IA 12345 ANYWHERE, IA 12345 JOHNDOE@HOTMAIL.COM .F. JOHNDOE@HOTMAIL.COM .F.and you can then populate ADDR1,2..6 etc.