Hi all
I'm using computed field to merge 3 fields and use it as a "search" views exposed filter.
Only one of the 3 fields contains string so the display is e.g "A(null)+B(string)+C(null)" and i've not
problem in site display.
The problem is that when i export the table view as excel file with Views Exporter the result in the excel column contains also "null" value in this ways:
| string |
|string |
| string|

This means that even if the computed field show only the filtered value in a views table, it "mantains" the blank spaces of added empty fields.

Is there a way to remove them or make something like "if(!empty...)" in computed fields?

thanks a lot for help

Comments

dqd’s picture

dqd
(formerly "diqidoq")
CreditAttribution: dqd as a volunteer and at MAROQQO studios commented
Issue summary: View changes
Status: Active » Closed (outdated)

Due to the Drupal core life cycle policy and security support advisery, Drupal 6 is no longer supported. So issues for Drupal 6 cannot be longer maintained. The project maintainer has asked for closing all D6 issues to clean up the issue queue. Feel free to reopen the issue if required or set it to "needs to be ported" and latest D8 dev version, if the issue discusses a still missing feature which can be implemented in the D8 version.