Hello,
I'm using the Report Text tool to format a letter for mass mailing, and some of the addresses have more than one address line, but when there aren't additional lines, it leaves a gap; anyway around this?
Below is the format used in the Report Text tool currently:
So if there is no Address Line 2 or 3 in the data, it will leave a gap in the output, for example:
Jane Doe
123 Main St.
Anytown, ME 11111
But would like it be:
Jane Doe
123 Main St.
Anytown, ME 11111
Thank you,
Kim
@kas which version of designer are you using? I don't see the extra line break if there is no field value present
You can create a new column called 'Address' via the formula tool. There you can use if statements/trims/etc to check if the column is empty and either do/don't add it to the 'Address' column. Then, render the address column through the reporting tool.
E.g. 1:
Address=
[Name] +"
"+[Add1]+"
"
Address =
IF !IsEmpty([Add2]) THEN
[Address]+[Add2]+"
"
ELSE
[Address]
ENDIF
Address =
IF !IsEmpty([Add3]) THEN
[Address]+[Add3]+"
"
ELSE
[Address]
ENDIF
Address =
[Address]+[City]+", "+[State] +" " + [Zip]
E.g. 2:
Using REGEX:
Address = [Name]+"_"+[Add1]+"_"+[Add2]+"_"+[Add3]+"_"+[City]+", "+[State]+" "+[Zip] //_ represents where you would want a line break
Address = REGEX_REPLACE([Address],"_+","_")
Address = REPLACE([Address],"_","
")
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |