I have an Address: "198 whitten farm Apt 3". I would like to count the number of blank spaces in the address. if it has more than 3 blank spaces I want to eliminate whatever is there after the 3 blank spaces.
Solved
Count the number of blank spaces
+4- Contributor
Best answer by erik_jan
A StringSearcher transformer with these settings will (in this case) return "198 whitten farm" in the _first_match attribute (you can pick another name or even the address.
The regular expression ^[^\\s]*\\s[^\\s]*\\s[^\\s]* is:
start, then any number of non-space characters, followed by a space, followed by any number of non-space characters, followed by a space ending in any number of non-space characters.
Hope this makes sense.
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.
+26- Contributor
- Best Answer
A StringSearcher transformer with these settings will (in this case) return "198 whitten farm" in the _first_match attribute (you can pick another name or even the address.
The regular expression ^[^\\s]*\\s[^\\s]*\\s[^\\s]* is:
start, then any number of non-space characters, followed by a space, followed by any number of non-space characters, followed by a space ending in any number of non-space characters.
Hope this makes sense.
+26- Evangelist
A StringSearcher transformer with these settings will (in this case) return "198 whitten farm" in the _first_match attribute (you can pick another name or even the address.
The regular expression ^[^\s]*\s[^\s]*\s[^\s]* is:
start, then any number of non-space characters, followed by a space, followed by any number of non-space characters, followed by a space ending in any number of non-space characters.
Hope this makes sense.
A variant of @erik_jan 's very good RegEx is alternatively:
(\S+\s+){0,2}\S+This is for a little more general purpose by:
- Trimming off any leading spaces that may exist in the string
- Dealing with situations where you may only have 1 or 2 words rather than just 3 or more, so it starts by looking for between 0 to 2 combinations of having 1 or more sequential Non-Whitespace characters followed by 1 or more sequential space characters followed by a 1 or more length of Non-Whitespace characters. So this can deal with say "198 whitten" or "whitten" as variants in the address string
+4- Contributor
A StringSearcher transformer with these settings will (in this case) return "198 whitten farm" in the _first_match attribute (you can pick another name or even the address.
The regular expression ^[^\\s]*\\s[^\\s]*\\s[^\\s]* is:
start, then any number of non-space characters, followed by a space, followed by any number of non-space characters, followed by a space ending in any number of non-space characters.
Hope this makes sense.
Thank you. That worked
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.