Skip to main content
Question

String Search to match feature sets

cg-wcc
Contributor
Forum|alt.badge.img+1

Hi,

Pretty new to FME, so hopefully I have all the terminology right and I’m asking the right sort of questions.

 

I have a feature set from Freshservice API of the available products in their asset system.
It’s mostly the Latitude and OptiPlex products I need to work with so the solution can work just for them.

I need to match the freshservice_product_name to a feature set that I don’t control and isn’t consistent.

As you can see the tesma-description is a bit of a mess but it’s all I have to try match up the freshservice_product_name to.


Can someone point me in the right track of how they would tackle this?

Thanks,

 

    danilo_fme
    1 person upvoted this
    • danilo_fme
      danilo_fme

    4 replies

    takashi
    Influencer
    • takashiInfluencer
    • April 23, 2025

    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.

    Tester Setting Example (Contains Operator)

     

    danilo_fme
    lambertus
    raghavendrans
    3 people upvoted this
    • danilo_fme
      danilo_fme
    • lambertus
      lambertus
    • raghavendrans
      raghavendrans
    geomancer
    Evangelist
    Forum|alt.badge.img+48
    • geomancerEvangelist
    • Evangelist
    • April 23, 2025

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

    danilo_fme
    1 person upvoted this
    • danilo_fme
      danilo_fme
    geomancer
    Evangelist
    Forum|alt.badge.img+48
    • geomancerEvangelist
    • Evangelist
    • April 23, 2025

    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.

    danilo_fme
    1 person upvoted this
    • danilo_fme
      danilo_fme
    cg-wcc
    Contributor
    Forum|alt.badge.img+1
    • cg-wccContributor
    • Author
    • Contributor
    • April 29, 2025

    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.

    geomancer
    1 person upvoted this
    • geomancer
      geomancer

    Reply


    Helpful Members This Week

    Community Stats

    31,341
    Posts
    118,858
    Replies
    38,942
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.