Solved

removing typos & matching meter IDs from two different datasets

G
Badge

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 

 

 

icon

Best answer by ebygomm 5 May 2023, 10:44

View original

2 replies

ebygomm
Rank
Userlevel 1
Badge +21

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:

G
Badge

Thanks, it helped! :)

Reply


Community Stats

28,724
Posts
109,518
Replies
36,564
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.