Parse NTEXT SQL Column into multiple columns for every word

255 Views Asked by At

Hello I have a ntext column that contains a check image. In this check image there are a hundred or so words and values. What I am attempting to do is convert each word or value into a separate column.

    Check_Image Column
------------------------------------
this is an image of a check
===========================
address
data 
bla 
bla
bla 25% 
849324890234874
Discount -.088 
Subtotal 2.62
card
33934923 john smith
I agree to pay
X ___________________
thank you!


------------------------------------

I am attempting to split each word into a separate column to retrieve data within the check image of how much discount what applied to the card of John Smith. Desired Output:

discount  subtotal     Bla 25%             card
--------  --------     ---------           ---------
-.088     2.62         849324890234874      33934923 John Smith

Thanks Guys

0

There are 0 best solutions below