Split on Newline LK
How to extract a particular line from text
This app shows how to extract lines from multi-line text using the SPLIT and INDEX functions.
Also see: tablet mode & fullscreen mode
How we built this app
To split the text into lines, we use this formula: SPLIT([Text], " ") Next, to access a particular line, we use this formula: INDEX([Split Text], 2) (That will return the second line.)
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.