Syntax

EXTRACTLINE ( line_number, stringToExtractLineFrom )

Arguments

line_number A line number to extract from the string.

stringToExtractLineFrom The string to extract the line from.

Returns

Returns a string containing the line at the specified line number. Empty string if the line number is invalid.

Example

The following example returns the third line from the string This\nis\nthe\nstring\nto\nuse.

query: |
  SELECT EXTRACTLINE(3, 'This\nis\nthe\nstring\nto\nuse') AS LineContents
template: |
  

[ { "LineContents": "the" } ]