Skip to main content
Solved

Help creating an expression with StringSearcher transformer.

  • September 13, 2021
  • 3 replies
  • 37 views
E

Hello, I'm trying to extract a number out of my comments column. I'm not sure how to write the expression? or if I'm using the right transformer? I'm still new with FME.

 

The number I am trying to extract is 8 digits and is put in comment field with this format "/ 12345678 /" an example of the format is below.

 

VB BLVD / 59208085 / L06-514 / ATT 8547

 

Is there a way to extract this number?

 

Thank you!

Best answer by danilo_fme

Hi @egeiser​ 

 

I created your case:

 

String 

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.

3 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • Best Answer
  • September 13, 2021

Hi @egeiser​ 

 

I created your case:

 

String 

Attached the Workspace.

 

Thanks in Advance,

 

Danilo

Partner Solutial Brazil - www.solutial.com.br
E
  • egeiser
  • Author
  • 1 reply
  • September 13, 2021

Hi @egeiser​ 

 

I created your case:

 

String 

Attached the Workspace.

 

Thanks in Advance,

 

Danilo

This worked! Thanks!

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • September 13, 2021

This worked! Thanks!

Awesome! I'm happy to help you!

Partner Solutial Brazil - www.solutial.com.br

Community Stats

32,070
Posts
121,771
Replies
39,696
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.