Bruce, it looks like the (CHAR(013)) is being ignored.
I'm not sure if column names (Addressee, Department, etc) can be
concatenated with "variables", ie, (CHAR(013)).
Might be a PITB, but what happens if your read Addressee into variable
vAddressee, Department into vDepartment, etc.,
and then
SET VAR vMailTo text =(.vAddressee + (CHAR(013)) + .vDepartment +
(CHAR(013)) + etc...)
What happens if SET ERR MESS ON is applied - invalid column name?
Just a stab in the late Sunday dark.
Doug
On 1/21/2024 7:31 PM, Bruce Chitiea wrote:
All:
I need to concatenate mailing addresses with variable line counts, for
envelope printing. For example:
Addressee
StreetAddress
CityStateZip
or:
Addressee
Department
Corporation
StreetAddress
CityStateZip
A Report Variable is placed within the Page Header of a table-bound
Report to serve as the printing breakpoint.
Simplified to focus just on line feeding[1] (ignoring the IFNULLing
required for variable line counts), the variable:
*( Addressee + (CHAR(013)) + Department + (CHAR(013)) + Corporation +
(CHAR(013)) + StreetAddress + (CHAR(013)) + CityStateZip )*
... produces this string, exactly where the address should be, one per
envelope:
*AddresseeStreetAddressCityStateZip*
or:
*AddresseeDepartmentCorporationStreetAddressCityStateZip*
Thoughts? And thanks.
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
[1] This has also been attempted with (CHAR(013)) + (CHAR(010)) . No
change.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em27004548-d51a-4171-a2b2-7304a415578b%40daaf866b.com
<https://groups.google.com/d/msgid/rbase-l/em27004548-d51a-4171-a2b2-7304a415578b%40daaf866b.com?utm_medium=email&utm_source=footer>.
--
This email has been checked for viruses by Avast antivirus software.
www.avast.com
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/7d843c89-695d-4edb-9c1e-0b4e608805cc%40wi.rr.com.
