Need a sql query to parse ntext column with distinct delimiters in the ntext value

Hello Experts,

I have a table with an ntext column as it's too big to be a varchar.

I have to parse through the ntext column and grab the data, and put it into normalised tables.

The data looks like this:
-----------------***********************-----------------

License Key                         = 50222249089062708117955
Product Name                        = VERITAS File System
Key                                 = Invalid,  Expired
License Type                        = DEMO
Demo End Date                       = Sun Sep 19 04:00:00 2004
Site License                        = YES

Features :=
VXFS                                = Enabled


-----------------***********************-----------------

License Key                         = 00194956550480519594652
Product Name                        = VERITAS File System
Key                                 = Invalid,  Expired
License Type                        = DEMO
Demo End Date                       = Sun Oct 24 04:00:00 2004
Site License                        = YES

Features :=
VXFS                                = Enabled


-----------------***********************-----------------

License Key                         = R8PG-OMNP-6CRU-PPPP-XU3N-D2OP-PPRP-P36
Product Name                        = VERITAS Volume Manager
Serial Number                       = 17615
License Type                        = PERMANENT_NODE_LOCK
OEM ID                              = 22
Node Lock Type                      = (Hostid and Architecture ID)

Features :=

VxVM                                = Enabled
CPU Count                           = Not Restricted
Platform                            = un-used
Version                             = un-used


-----------------***********************-----------------


..and it's not terribly consistent either. (The above is just a small fragment for an example)

What IS consistent with the data in the ntext column however is that sections of it are separated by the -----------------***********************----------------- thing.

What do you think is the best way to parse through this and pull out the data items with their relevant values?

I have to do it on SQL, but it's coming from a text file so maybe there's a better way?

As ever, super urgent!!!!

Thanks,
rss2
rss2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BrandonGalderisiCommented:
If you can parse the text file with some type of scripting language (like vbscript or javascript) you can probably handle it MUCH better.  You can do a split on the _______*************__________ line to break it into smaller sections.  Then from there read line by line to break up the fields.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what version of sql server?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.