SQL Server 2012 - Inserting multiple records from one block of text, Sql Server

Language: Layout:

create function [dbo].[delimitedsplit8K] (
          @pstring varchar(8000)
        , @pdelimiter char(1)
      )
    returns table with schemabinding as
     return
      with e1(N) as (
        select 1 union all select 1 union all select 1 union all 
        select 1 union all select 1 union all select 1 union all 
        select 1 union all select 1 union all select 1 union all select 1
      )
      , e2(N) as (select 1 from e1 a, e1 b)
      , e4(N) as (select 1 from e2 a, e2 b)
      , ctetally(N) as (
        select top (isnull(datalength(@pstring),0)) 
          row_number() over (order by (select null)) from e4
      )
      , ctestart(N1) as (
        select 1 union all
        select t.N+1 from ctetally t where substring(@pstring,t.N,1) = @pdelimiter
      )
      , ctelen(N1,L1) as (
        select s.N1,
          isnull(nullif(charindex(@pdelimiter,@pstring,s.N1),0)-s.N1,8000)
        from ctestart s
      )
     select itemnumber = row_number() over(order by l.N1)
          , item       = substring(@pstring, l.N1, l.L1)
       from ctelen l
    ;
    go
    
create table dbo.note (
    id int not null identity(1,1) primary key 
    , created datetime2(2) not null
    /* other cols */
);
create table dbo.note_lines (
    id int not null identity(1,1) primary key
  , noteId int not null foreign key references dbo.note(id)
  , noteLineNumber int not null
  , noteLineText varchar(8000) not null
);

declare @noteId int;

insert into dbo.note values (sysutcdatetime());

set @noteId = scope_identity();

declare @note_txt varchar(8000) = 'On SQL server 2012. I have normalized tables that will consist of "notes". Each "note" record can have many notelines tied to it with a foreign key. I''m looking for a SQL statement that will parse a block of text and, for each line within that text, insert a separate record.
I''m guessing some sort of "WHILE loop" for each block of text but can''t get my head around how it would work.
To be clear: The end result of this would be to just paste the block of text into the query and execute so that I can get each individual line of it into the note without messing around creating multiple insert statements.'

insert into dbo.note_lines (noteId, noteLineNumber, noteLineText)
select @noteId, s.ItemNumber, s.Item 
from  [dbo].[delimitedsplit8K](@note_txt, char(10)) s

select * from note;
select * from note_lines;

View schema
Execution time: 0,03 sec, rows selected: 6, rows affected: 4, absolute service time: 0,17 sec