Split() on Newline

AppSheet AppSheet Q&A
,
1

Hello All..

All of the examples I have seen of Split() are delimited by spaces or commas. How do you Split with a newline as a delimiter?

Thanks,

Roryf

2

Based on your previous post Idk if SPLIT() it’s the solution for the whole problem, but you can try:

SPLIT(
[ColumnToSplit],
"
"
)
1 Like
3

Thanks for the reply. I thought there might be a more specific way to denote a newline (CR/LF). I will play around with it..

Thanks,

RoryF

1 Like