Skip to main content
  • EN

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 

 

 

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:

Thanks, it helped! 🙂

Reply


Community Stats

30,162
Posts
114,484
Replies
37,809
Members
Terms & ConditionsCookie 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.