Template
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.
Loading...
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.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...