Doug:
Ran an experiment defining the address string within a view-creating
.RMD file. Included the string first as a literal, then as an ampersand
variable within the AS SELECT. Fail. Tried each approach where the
(CHAR(013)) was inserted as a variable value. Fail.
See my answer to Mike Byerley's response, which I should have out in a
few minutes.
Thanks, as ever, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
------ Original Message ------
From "Doug Hamilton" <[email protected]>
To [email protected]
Date 1/21/2024 7:14:50 PM
Subject Re: [RBASE-L] - Mailing Address Line Feed Fail
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>.
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
Virus-free.www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
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
<https://groups.google.com/d/msgid/rbase-l/7d843c89-695d-4edb-9c1e-0b4e608805cc%40wi.rr.com?utm_medium=email&utm_source=footer>.
--
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/em2d620bb2-c1c3-4da1-ae08-00cb2feae42d%40daaf866b.com.
