MS SQL code for text pattern extraction

1 code should work fast for millions of rows and ~ 300 characters for each row text
2 you provide also code to create input table in SQL
3 output created as new column in this table
4 pattern fixed for all rows


INPUT DATA

row data pattern abc qwer tyui zxcv with many spaces

asdfasdf sadfgsdfg sdfgsdfg abc qwer tyui sss zxcv : tgb yhn uj m
m lkoipujdsf sdfgsdfg ksdgfdsfg abc qwer tyui zxcv : kiml mnk hbu asdfas eefd
zxdvxfdhhdfss dfsdf fdsf fsdf s sdfsdfsdfasdf abc qwer tyui s zxcv : wsxkk cde zsedcf nnhuhg
;lkasdfj as;dlfkjasdf [posidf asd fafsdopoasdfi fiasdop[

OUTPU 1 new column
processed data N1 parameter 7 characters after pattern

abc qwer tyui zxcv : tgb yhn
abc ss qwer s tyui zxcv : kiml mn
abc sss qwer s tyui zxcv : wsxkk c
NAN

OUTPUT 2 new column
processed data N2 parameter 7 characters after pattern but no space in pattern

abc qwer tyui zxcv : tgb yhn
abc qwer tyui zxcv : kiml mn
abc wer tyui zxcv : wsxkk c
NAN