Not more than 3 at the most 4

this is the output I'm looking for. To extract every TBM number for each Sol_Id and have them in the same row as shown below only if they are complete...

Hi,

What I meant was if I have a Sol_id. How do I put the TBM numbers from the same string as item1,item2 etc but in one row and keeping...

Hi

works nicely but when I encounter a string like this one

INSERT #Test VALUES('TBM907 - 16/03: provided a new ,of TBM908 - 02/03: TBM908 has TBM908')--- I want to extract all...

Thank you.. It works....

I have attached the sample text file I have received. And this is for Situation 2. Movies is for situation 1

Its directory contents. Thats How I received them in the form of a text file . Its just a string