I need to concatenate 3 fields before exporting to CSV

A catalogue number comprises 3 fields from a query
For example: field1-field2-field3
This must export to ONE column in Excel (other fields are exported as well)

Is there a workaround for this in Server Data Formatter?

Or should I create a view in phpmyadmin like so?:

SELECT CONCAT(field1, "-",field2, "-", field3) AS catalogue_no
etc, etc

Hi David,
Unfortunately there is no such an option available for the data exporter available. The best way is to create a view.