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
  • 37 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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • 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.