Using Replace tool

[corinne]

Hi 

Not sure if anyone can help. 

I have multiple records that have directions in the beginning and the end. 

do you know how I can remove it from my record and create the Parsed columns. 

Reason is currently they are not matching because the direction from both files (different sources) are recorded differently. 

Example 

REC_Id	Street_name	Parsed Street Name	Parsed street name Direction	Joined St_Network
1	Jane St W	Jane St	W	W Jane St
2	SW Bob Blvd	Bob Blvd	SW	Bob blvd SW
3	11th ST E	11th ST	E	E 11st St

Any help would be very welcomed. 

thanks, 

Corinne

[pedrodrfaria · Accepted solution]

Hi @corinne 

You would be looking at Fuzzy Matching as a solution.

Pedro.

[markcurry · Accepted solution]

Hi @corinne 

You can use the formula ....

Replace([Joined St_Network], [Parsed street name Direction], "")

to remove the directions from the street name.  This will leave trailing or leading spaces, so use the Data Cleansing tool afterwards.  I hope that helps.

Mark 

[corinne]

ahh it worked but it also removed the other letters that is in the record. 

is there a way to just removed the Direction letter (E, or W etc)?

[markcurry · Accepted solution]

Hi @corinne 

Sorry I should have thought that the replace function would remove all instances of N, S, E etc.   I've attached a workflow with a different method,  it checks if the street name either begins or ends with the direction, and if it does it removes that from the beginning or end of the street name.  

Mark