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.
+2
- Participant
- 594 replies
-
21 July 2015
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.
+2
- Participant
- 594 replies
-
21 July 2015
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.
+2
- Participant
- 594 replies
-
22 July 2015
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.