Solved

Separate address values in a single field on left and right side of "/" separator to a new field

  • 21 October 2022
  • 1 reply
  • 4 views

Userlevel 1
Badge +15

I have a table of addresses with these values in a single field, example: Main St/Carter Ave. I want to put Main St in a new field named StreetName, and Carter Ave in a new field named IntStreetName. I know there must be a method for parsing the values to the left and right of the "/" separator. How can I do this in FME?

 

I know how to do this in python using split. I am new to FME.

icon

Best answer by geomancer 24 October 2022, 10:14

View original

1 reply

Userlevel 4
Badge +36

There are many ways of accomplishing this in FME.

Use an AttributeSplitter to create a list, followed by an AttributeManager to extract the list values to attributes.

Or use regular expressions in an AttributeManager.

Split_AdressesIf you want to, you can even do it in Python, using a PythonCaller.

Reply