Skip to main content
Question

Convert Multi-line Text to multiselect text using line breaks as delimiters

  • January 14, 2021
  • 0 replies
  • 127 views
Hello!

I am trying to convert a multiline text field to a multiselect txt by using a formula multiselect text field. 

I tried:

Split([Rack Barcodes],"\n")

And I also tried:

Split(searchandreplace([Rack Barcodes],"\n",";"))

but it seems that neither searchandreplace() nor split() are able to find a "\n" newline in the text. Any help appreciated!

------------------------------
Tyler M
------------------------------
This topic has been closed for replies.

  • NathanHawe
  • Registered
  • January 14, 2021
I tried your exact setup there with Split([Field],"\n") and that worked as expected.  I did that on Windows in Chrome and on Mac with Safari and both instances worked.  In both instances I typed directly into the multi-line text field and the split resolved after I saved the record.  Are you copying a block of text from some other application that could be using a different encoding for line feeds such as "\r"?

------------------------------
Nathan Hawe
------------------------------
Terms & ConditionsAccessibility statement