Question SSIS Term Extraction

[oscarsc]

I am doing a term extraction of a table in SQL Server Business Intelligence 2005, in wich the data of each row of the column is something like this:

Date: 10/30/2006 6:00:57 AM Status: This is the status Second Status: this is the second status Warnings: Warning1, Warning2 Errors: ... Description SD0003 72-01 Detailed description... Description SD0001 95-01 Detailed description of alert two 07-515 17-09 Detailed description alert three.

and I have thousand of rows like this...

I do it with the following characteristics:

Term: Noun and noun phrase
Score: Frecuency
Params: 1, 50

My objective is to obtain 07-515 17-09 and 72-01 as one of the terms..but I have tried everything I know and I can't resolve it, how can i do it?

I receive a lot of terms with sense and useful for me, but not those ones which are composed of integers..

Thank you in advance.

 

[MDXer]

Well the good news is that it is you and not me that has to accomplish this. The good news part 2 probably not impossible. The bad news it is going to be hard and require some custom scripting.

Only way I can see to accomplish this really is to use a script task with regex in the script code to parse the string.

GOOD LUCK!