P1263P3753*P1263P1397*P1263P3753*P1263P2635**001262*001512*002589*002690*002691*002692*002920
P1263P1263P1275P1263P1275001276P1263P1275001960P1263P1278P1263P1278001279P1263P1278001280P1263P1278001289P1263P1278001291P1263P1278001292P1263P1397P1263P1397001400P1263P1397001406
The first one breaks down into something like this
Code:
PrimPart SecPart TerPart
P1263
P1263 P3753
P1263 P1397
P1263 P3753
P1263 P2635 001262
P1263 P2635 001512
P1263 P2635 002589
P1263 P2635 002690
P1263 P2635 002691
P1263 P2635 002692
P1263 P2635 002920
You said a * at the end of the secondary part of the part number indicates it has a tertiary part, but how do you tell based on the the string which tertiary part belongs to which secondary part? I just assumed because they all belonged to the one that they immediately followed in my example.
Your second string would break down to
Code:
PrimPart SecPart TerPart
P1263
P1263 P1275
P1263 P1275 001276
P1263 P1275 001960
P1263 P1278
P1263 P1278 001279
P1263 P1278 001280
P1263 P1278 001289
P1263 P1278 001291
P1263 P1278 001292
P1263 P1397
P1263 P1397 001400
P1263 P1397 001406
]how would you intend to link the data in these two strings? The only thing they have in common is the primary part number P1263. Is that what you're interested in you want to collect all parts and sub parts from both tables in one collection?