Loading

How To Split Delimiter Separated Values Into Value Based Buckets?

Дата публикации: Mar 31, 2025
Задача
How to split delimiter separated values into value based buckets.
Example: Splitting the below column rows into columns having their respective values   
2,3
4,5,2,3
3
2
into 
23  
2345
 3  
2   
 
Действия
Create different calculated fields like below Where A is the Column name having comma separated values in rows:

Calculated field name: 2

if CONTAINS([A],"2")=TRUE then "2" ELSE ""
END

Calculated field name: 3

if CONTAINS([A],"3")=TRUE then "3" ELSE ""
END

Calculated field name: 4

if CONTAINS([A],"4")=TRUE then "4" ELSE ""
END

Calculated field name: 5

if CONTAINS([A],"5")=TRUE then "5" ELSE ""
END

User-added image

 
Дополнительные ресурсы

Using Custom Split will split the content only based on Order of the values in which they appear .

Номер статьи базы знаний

001453841

Вложения

Example.twbx

8 KB

 
Загрузка
Salesforce Help | Article