Question
Regex to qualify the attributes of shape file and copy them to appropriate fields
I am working with ESRI shape files and the data in on of the attribute field in my existing dataset is a mix of information that needs to qualified and segregated into atleast 4 new attribute fields. I hope using regular expressions would be the best way to accomplish this task. I donot have too much experience wotking with FME and I was hoping to see if anyone here has a workspace that you used for somethjng similar that I could refer to . Any help in this is appreciated as all I have now is the regular expressions that will help me qualify the data.
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.
+12- Contributor
Hi,
Question is too generic for me... :)
What do you mean by "mix of information" and what are "4 new attribute fields" you expect???
Could you please explain with an example atleast to understand better...
Am working on an address dataset. The address number field in the current dataset contains address number, subaddress info, lot numbers, etc. I am planning to qualify them and put in seperate fields.
+12- Contributor
1. address number
2. subaddress
3. lot number
are present in single attribute field?
Exactly. They all are present in a single attribute field now.
+12- Contributor
If you have any delimiter then use "AttributeSplitter", else if you are confident of number of characters then use "SubstringExtractor".
Hope this will help
Thanks for the replies. By the way, I got it working yesterday by chaining up StringSearcher with Substring Extractor and then to AttributeCopier.