MS SQL server code for text pattern extraction
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
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