Skip to main content
Solved

removing typos & matching meter IDs from two different datasets

grayson
Contributor
Forum|alt.badge.img+3

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:

View original
Did this help you find an answer to your question?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • ebygommInfluencer
  • Influencer
  • 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+3
  • graysonContributor
  • Author
  • Contributor
  • May 8, 2023

Thanks, it helped! :)

Reply


Helpful Members This Week

Community Stats

31,402
Posts
119,074
Replies
39,019
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.