Hi.
Can someone help me build an expression that would divide this multiselect field from ZOHO CRM by removing these caracters: [ " ] to make them only comma separated?
Field name is Product Lines
Product Lines ["Self Propelled","Trailers","Linkage","Parts/Small Sprayers","Viticulture"]
Thank you so much
Hello Dennis, Please try the following expression for the ProductLines field:
replace(replace(replace(replace("Product Lines", '"', ''), ',',', '),'[',''),']','')
You can use the Preview function of the expression editor to check the expression before saving it.
Please inform us about the result.
Best regards,
Olena
Technical Support Engineer
