.. _wrap-output-quote-snip:

======================
Wrap Output in Quotes
======================

Sometimes you need to wrap the output data ion quotes.  For example you have data that is pre-fixed with 0 and when you iport the output into Excel it drops the 0, so you want to wrap that data in " ".

Rule Type Format
=========================

    concat('text value' , field name , 'text value')


Snippits
=========================


Wrap in ""
--------------

Puts a " at the beginning and end of the field value.


Convert Text in Field
++++++++++++++++++++++

Rule Type = Calculated Output Field

Rule Attribute = concat('"', postCode , '"') : PostCode


Examples
+++++++++

* 5035 become "5034"

* 0340 becomes "0430"