Skip to main content
Solved

Formular change seperator


Forum|alt.badge.img

by a normal multiple selector ist the normal seperator a ,
how can i seperate with ; instead , ?

Best answer by Justin_Barrett

This will change all commas to semicolons when referencing a multiple-select field:

SUBSTITUTE({Multiple Select}, ",", ";")

View original
Did this topic help you find an answer to your question?

2 replies

Justin_Barrett
Forum|alt.badge.img+20
  • Inspiring
  • 4647 replies
  • Answer
  • November 22, 2019

This will change all commas to semicolons when referencing a multiple-select field:

SUBSTITUTE({Multiple Select}, ",", ";")


Forum|alt.badge.img
  • Author
  • Known Participant
  • 22 replies
  • November 22, 2019
Justin_Barrett wrote:

This will change all commas to semicolons when referencing a multiple-select field:

SUBSTITUTE({Multiple Select}, ",", ";")


thanks you are awesome!


Reply