address field issue

[wolverinec7]

hi all, i have written a letter using crystal bringing a number of fields through. at the top are the 5 address fields. however my data isnt 100% complete. some might have nothing in addr 2 but something in 3 so there's a gap in the address which looks bad.

i know the answer is using an array but im not quite sure how.

eg it currently looks loke

addr1 Mr Smith
addr2 1 any road
addr3
addr4 london
addr5 ec1w 1re

and i want it to move the londong and postcode up.

thanks in advance

carl


Using Crystal v10

 

[wolverinec7]

for anyone who's interested i solved my own problem

where {@address},= addr1 & ", " & addr2 & ", " & addr2 & ", "& addr4 & ", " & addr5


i used:
Local stringvar array x := split({@address},',');local stringvar y;local numbervar i;for i := 1 to ubound(x)Do( if x <> '' then y := y & LTrim(x) & chr(10));y

Using Crystal v10