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
Solved! Go to 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
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)?
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