Skip to main content
Solved

removing typos & matching meter IDs from two different datasets

  • May 5, 2023
  • 2 replies
  • 15 views
grayson
Contributor
Forum|alt.badge.img+7

Basically, I want to match meter IDs from two different datasets: shapefile and excel file.

 

Meter IDs in both datasets might have typos such as dashes, dots, letters, slashes, which I need to remove first.

 

Then I want to match MTR_NO from Excel against Mother_1 , Child_3, & Child_4. My idea is to export an excel table that will include only matching meter IDs.

Zrzut ekranu 2023-05-05 101140 

 

 

Best answer by ebygomm

You could use a StringReplacer to replace anything that is not a number with nothing to get just the numeric meter id

Mode: Replace Regular Expression

Text to Replace: [^\\d]

Replacement Text:

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.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • Best Answer
  • May 5, 2023

You could use a StringReplacer to replace anything that is not a number with nothing to get just the numeric meter id

Mode: Replace Regular Expression

Text to Replace: [^\\d]

Replacement Text:

grayson
Contributor
Forum|alt.badge.img+7
  • graysonContributor
  • Author
  • Contributor
  • 3 replies
  • May 8, 2023

Thanks, it helped! :)

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.