Table Of Contents

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”

Table Of Contents

• Wrap Output in Quotes
  • Rule Type Format
  • Snippits
    • Wrap in “”
      • Convert Text in Field
      • Examples

arrow_back

Previous

Change Text Case

arrow_forward

Next

Trust