My data table looks like this:
RowID DetailData
1 0BATCH NEXTGEN NEXTGENEMR 20160829CPM 651
2 1P0007.63579.0000 1609168541 899972053 1230 CN25
3 2P201608232016082399348 1 0 1
4 51 401.9
5 52 719.45
6 71609168541
7 1P0007.63512.0000 1093765679 100458751 1230 CN25
8 2P201608262016082699347 1 0 1
9 51 787.01
10 71093765679
11 1P0014.236945.0000 1174807291 2254912701 1230 GW23
12 2P201608252016082599341 1 0 1
13 51 402.10
14 52 272.2
15 53 250.00
16 54 244.9
17 55 414.01
18 56 278.02
19 57 V85.24
20 71174807291
The Detailed Data column needs to be separated into separate COLUMNS of data based on the TAB spacing.
Each Full Record contains Rows that start with "1,2,5 and 7". I believe there can be 1 or many rows for each "1,2,5,7" but it appears that most multiple rows show up in the "5" type.
I need help in creating a sql script that will step through this table and separate the DetailedData field into separate fields.
Thanks
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.