Value.Split(LineBreak()) isn’t working, and neither is Value.Split(Character(10)) or Value.Split(Character(13)). I’ve created an example doc (below). The “Num Lines” values should all be 5, as the CSV file in the “Value” column is made up of 5 rows. Coda support suggested I post this in the forums. Does anyone have suggestions on how I can split a text value based on line breaks?
If I erase the first “linebreak”, and replace it with alt+enter, it’s OK and the split works. I assume the break you have is not exactly the same as “official” one, but I lack capacities to know the difference and how to track it without changing all your input data
The input definitely has line breaks – there are 5 rows of comma separated values. Coda has two different ways of creating a line break – Shift+Enter or Enter. However, both create a character that should be able to be used as a character for splitting. If not via LineBreak(), then at least via Character(n). It’s an odd bug. I also think it was working properly until a few weeks ago, but I’m not sure.