"Attribute Filter"

Question

I am using the ExcelExample Source to bring in a new spreadsheet.  The I am using the Atttribute Filter.  Is there a way to have the parameter string equal 2 strings?  I have it set for the attribute "comments" right now and want to include the group and costs.

patrick145 · Answer

I've also noticed that you can get fancier with these filters via regex. I am guessing that the backing implementation is standard java regex. Here I filter out all fields ending in -FIELD- followed by a single digit. Filtering out being specified by the "true" value in the "invert_filter" argument. Otherwise, it'd be an inclusive filter rather than an exclusive one.

TobiasMalbrecht · Answer

Hi Stacy, just use the [tt]AttributeFilter[/tt] and specify "Comment|Amount" as parameter [tt]parameter_string[/tt], or simply take the following code ... ;) Hope that solves your problem. Regards, Tobias

shilaski · Answer

Tobias,

Do you have an example? :)

Here is what I have

Number                Comment                                                                                         Amount

1                           Trailer lights don't work because the connection is loose            $75.08
2                           Rear lights blink intermittantly                                                        $125.73
3                           Trailer light stopped working water in the connection                 $23.34
4                           brake light are inop                                                                       $34.56
5                           Dome light doesn't work                                                               $87.23

When I pull the data in from an Excel spreadsheet the data will have 3 attributes.....Number Comment and Amount.  I used the attribute filter to just get the comments so I could create word vectors from the comments.   Now I would like to also pull the amount with the comment.  Maybe I need a model shift here? :)