String Search to match feature sets

Hi ​@cg-wcc ,

Do you need to extract only rows whose "freshservice_product_name" value begins with (or contains) "Latitude" or "OptiPlex"?

If so, you can use Tester or TestFilter simply with operator "Begins With" or "Contains".

The criteria was more complex, “Contains Regex” operator or StringSearcher transcormer could also be helpful.

Maybe the FuzzyStringComparer from FME Hub can be of help here.

Maybe you can add an extra attribute in FME to the table containing tesma description, something like

• Remove the word Dell
• Remove the word Macro
• Maybe some more actions
• After that, keep only the first 2 words

Hopefully now only the two words remain that are present in freshservice_product_name.

Thanks everyone, I’m going to use a combination of all your suggestions.

I found I can bring in another data source matched on serial number with the model details formatted perfectly, but I’m still going to match them off with a search against the tesma-description as I’ve found some of the descriptions are for the incorrect family and model.