Question
Parsing attribute values
I have a workspace that compares a PATH HIERARCHY data set attribute of video file names to a GeoMedia Feature data set attribute of sewer segment names and does a feature merger on the two datasets when there is a match. Sewers are usually videod from upstream to downstream and the video files are named according to the direction in which the camera was travelling. My workspace gets quite a few matches BUT...there are occasions where the videos are named from downstream to upstream which causes my feature merger to send that video name to the incomplete branch. I would like to parse the video name attribute and use the result to create a new attribute that is the reverse. So 'MH07-121 to MH07-122' would become 'MH07-122 to MH07-121' in the new attribute. Could someone please suggest an approach that would accomplish this for me? Thanks.
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.
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.
+21- Safer
Hi,
I would parse the attribute value with a regular expression = string searcher and reconcatenate the matching parts (string concatenator) to form the new value.
Hope this helps.
+21- Safer
As always there are more than one way to do things in FME, so if you value is separated by ' to' you can use that as the delimeter value in the attribute splitter and then reconcatenate the list values.
Yes, there should be some approaches.
I would use StringSearcher, Tester and StringReplacer.
Takashi