Picklist Values: Replace Semicolon with Comma

Replace semicolon-delimited field output with commas in merge fields and related list columns.

Fields that return semicolon-delimited values can be cleaned up at render time.

Use #COMMA# when the replacement value must contain a literal comma.

Problem

The replaceall attribute uses commas to separate each search and replacement value.

If you enter a literal comma as the replacement value, S-Docs reads it as part of the attribute syntax.

That means a pattern like replaceall=";,," does not work as expected.

Solution 1: Replace semicolons in a merge field

Use this pattern when you output the field directly in the template.

merge-field-example.txt

{{!docsight1.General__c replaceall=";,#COMMA#"}}

Example

Field value

Alpha;Beta;Gamma

Rendered output

Alpha,Beta,Gamma

Solution 2: Replace semicolons in a related list column

Use this pattern when the field appears inside lineitemsSOQL.

related-list-column.xml

<column replaceall=";,#COMMA#">docsight1.General__c</column>

Example

related-list-example.xml

<lineitemsSOQL>
  <soql>
    SELECT docsight1.General__c
    FROM Your_Object__c
    WHERE Parent__c = '{{!Parent__c.Id}}'
  </soql>
  <column replaceall=";,#COMMA#">docsight1.General__c</column>
</lineitemsSOQL>

Field value

Alpha;Beta;Gamma

Rendered output

Alpha,Beta,Gamma

Token reference

Use this token when a replacement value needs a comma.

Token	Represents
#COMMA#	,

Related articles

• How to Replace Values with Different Text
• Merge Fields With Template Editor