I am trying to split data, looks like there is some special character or white space that is not letting me to split.
i try to split with space as delimiter even though there is space between two A2339 MC it will not split.
-- test date
DECLARE @TEST_STR TABLE
TEST_STRING NVARCHAR(255) NOT NULL
INSERT INTO @TEST_STR(TEST_STRING)
(N'A2339MC ab Annual report131.39 131.39 00
,(N'44287QC New abc 65250.00 00250.00
--expected o/p should be
select 'A2339','MC ab Annual report','131.39','131.39','0','0'
union select '44287','QC New abc 65','250.00','0','0','250'