Drupal Association members fund grants that make connections all over the world.
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 |
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