What I do is a series of updates in cases like this
UPDATE directory SET col 10 = col 11 WHERE col 10 is null
UPDATE directory SET col 11 = NULL WHERE col10 = col11
-- I know there are more efficient ways to do this, but this is easy to
type. ;)
UPDATE directory SET col9 = col10, col10 = col11 where col 9 is null
UPDATE directory set ....
You could even use the #11 for the column and get away with it. The
trick, I found, is to start at the end and wade your way back until the
NO data message comes up. In a program I set an exit when it runs out of
data or just let it go by turning the "not found" message off before and
on after. R:Base is so fast (even in 2.11 days) that the update can do
thousands of records in nothing flat.
A temp table for the report is perfect.
Albert
On 2016-04-06 4:00 PM, [email protected] wrote:
Expanding on that a little.
In a label I define the first field (easy) ,and then using ifexists
(or ifnull) you can build each variable to print, The first few aren't
very hard, but the more you nest, it gets hard to keep it straight.
On Wednesday, April 6, 2016 at 2:59:02 PM UTC-5, bmilyard wrote:
I’m printing a directory of names and addresses with cell phones
and email addresses.I’m printing in this format:
Last Name, First Name
Address, City, State, Zip
Home Phone
Primary Phone
Secondary Cell
Primary Email
Secondary Email
Some folks do not have all the phone or email addresses available
so I want to eliminate the blank lines.I found the ‘Creating
Address Line Compression’ description in the Help file but it does
not work.I’ve combined all phone and emails into one variable and
placed the variable in a Variable Memo control field then checked
the ‘Suppress Empty Lines’ option.
Here’s my variable:
(HOMEPHONETEXT+(CHAR(013))+PRIMECELLTEXT+(CHAR(013))+SPOUSECELLTEXT+(CHAR(013))+PRIMEMAILTEXT+(CHAR(013))+SPOUSEEMAILTEXT+(CHAR(013)))
I even tried for each phone and email but they still did not work.
(HOMEPHONETEXT+(CHAR(013)))
What am I missing?I still have not upgraded to version 10.
--
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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/241dd4f1-29d8-4c09-bb4e-993701376e18%40googlegroups.com
<https://groups.google.com/d/msgid/rbase-l/241dd4f1-29d8-4c09-bb4e-993701376e18%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
--
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/57059121.5030201%40albertberry.com.
For more options, visit https://groups.google.com/d/optout.
