Skip to main content
Solved

How to use an attribute in the Regular Expression field of StringSearcher?

  • June 4, 2021
  • 5 replies
  • 168 views

toedeledokie

Hi there!

The attribute is composed of concatenated values.

When I test if the concatenated values work as a regex, it succeeds:

02But when I try and use the created attribute, it doesn't match.

01I would love your input, please.

Best answer by danilo_fme

Hi @toedeledokie​ 

 

Attached the Workspace.

 

 

Thanks in Advance,

Danilo

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • June 5, 2021

Hi @toedeledokie​ 

 

You need to use the transformer to merger your informations, like the transformer FeatureMerger ou FeatureJoiner before the StringSearcher.

 

 

Thanks in Advance,

Danilo


toedeledokie
  • Author
  • 4 replies
  • June 5, 2021

Hi @toedeledokie​ 

 

You need to use the transformer to merger your informations, like the transformer FeatureMerger ou FeatureJoiner before the StringSearcher.

 

 

Thanks in Advance,

Danilo

Appreciated. Will give it a go. Fought a bit with it all earlier today 🙂


toedeledokie
  • Author
  • 4 replies
  • June 6, 2021

Sorry @danilo_fme​ ,

I've had no success with FeatureMerger. Both columns have to have the same values, no? Name in file_a and Name in file_b differ but have substrings in common.

I pored over the FeatureMerger documentation as best I could.

File_a:

file_a_nameFile_b:

file_b_name Workspace:

workspaceHere's my workspace attached, with some of the files. There are more files I need to do this kind of merger with but it's gotta succeed first with file_a and file_b.


danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • Best Answer
  • June 8, 2021

Hi @toedeledokie​ 

 

Attached the Workspace.

 

 

Thanks in Advance,

Danilo


toedeledokie
  • Author
  • 4 replies
  • June 8, 2021

Hi @toedeledokie​ 

 

Attached the Workspace.

 

 

Thanks in Advance,

Danilo

Amazing, thank you! I could not, for the life of me, figure out how to pass along the regex and you whipped this up making it look so easy.

A million thanks for the lesson 🙏