Skip to main content
Solved

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

  • October 21, 2022
  • 1 reply
  • 28 views

vxn43
Supporter
Forum|alt.badge.img+18

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.

Best answer by geomancer

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.

View original
Did this help you find an answer to your question?

1 reply

geomancer
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • Best Answer
  • October 24, 2022

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings