View Single Post
 
Old 09-01-2015, 12:35 PM
Echevca Echevca is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Aug 2015
Posts: 3
Echevca is on a distinguished road
Default Thank you!

Thank you, thank you, thank you for you quick response during the weekend. I was having computer problems so I was unable to thank you right away.

It seemed to have worked with the products that had values listed one after the other on one line. I ventured into adding a ¶ after each product mergefield so that the products appear one over the other, but in doing so I get an empty row that I don't need/want...how do I get rid of those blank rows or how do I get the results to list without empty product lines?

This is the edited version for Products A-C taking your formula and adding the extra ¶

{ IF { MERGEFIELD "Product A" } <> "" "Product A : { MERGEFIELD "Product A" }¶" }¶{ IF { MERGEFIELD "Product B" } <> "" "Product B : { MERGEFIELD "Product B" }¶" }¶{ IF { MERGEFIELD "Product C" } <> "" "Product C : { MERGEFIELD "Product C" }¶" }¶

So right now I get the following look:


Product A #%

Product C #%
Product D #%


I want to eliminate that extra empty row that pertains to Product B (which didn't populate because it didn't have a value....which is what I wanted/needed)

Thanks in advance!
Reply With Quote