MS SQL server code for text pattern extraction

Job ID: 35616607

Budget: $10 – $30 CAD

INPUT DATA

row data pattern abc qwer tyui zxcv with many spaces

asdfasdf sadfgsdfg sdfgsdfg abc qwer tyui 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 zxcv : wsxkk cde zsedcf nnhuhg
;lkasdfj as;dlfkjasdf [posidf asd fafsdopoasdfi fiasdop[

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

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

OUTPUT 2 new column
processed data N2 parameter 7 charactres 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
Related categories: SQL Microsoft SQL Server