Try something like this: (IFEXISTS(coname2, coname2,(IFNULL(coname2,(IFEXISTS(coname3,coname3,' ')),' '))))
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]. 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/948c5680-d9f9-4f88-9bb5-2eeaaf304b83%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
