Split() on Newline

[RoryF]

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

[SkrOYC]

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

SPLIT(
[ColumnToSplit],
"
"
)

[RoryF]

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