Formula to split and wrap text values

Question

I know the following is possible in Apex, but I'm wondering whether there's a way to do it with standard formula fields.

Is there a way to split up a value and wrap each bit in other text values? For example (not a real example:

Custom_Field_1 = 'This;That;Other;', but could have any number of terms.

Formula for Custom_Field_2 should wrap each term delimited by ; in  and remove the ; to result in ThisThatOther.

Is this for the missing feature of frequency reporting for Multi Select Picklists by any chance? Using this formula, or something like it, may make it easier to export to excel and do pivot tables to do the reporting. — JodieM, Commented Aug 10, 2012 at 9:25

David Gillen · Accepted Answer · 2012-08-09 14:41:45Z

9

A basic solution for the formula would be

'<p>' &  SUBSTITUTE(Custom_Field_1, ';', '</p><p>')   & '</p>'

You can add logic to test if Custom_Field_1 is blank and leave the formula field blank in that instance too if necessary.

answered Aug 9, 2012 at 14:41

David Gillen

2,9973 gold badges20 silver badges26 bronze badges

Add a comment |

1 Answer 1