Parsing Out City Name
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
lbolin
8 - Asteroid
02-16-2023
07:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
5 REPLIES 5
Qiu
21 - Polaris
02-16-2023
08:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lbolin
Parsing City Name is always tricky.
Maybe you want to use my reply below.
Raj
16 - Nebula
02-16-2023
08:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you can use formula tool as well to get the last word
Getword([Field],(Countwords([Field]))-1)
gaoa
11 - Bolide
02-16-2023
08:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @lbolin
Is it possible to add a comma delimiter around city names or export one-word vs. two-word city names separately?
Below RegEx expression works for city names with one word.
02-17-2023
07:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This solution catches the first word it comes to in the list. It doesn't account for city names in the address.
example:
1274 Claremont Ave Ashland output: Claremont
Qiu
21 - Polaris
02-17-2023
02:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lbolin
Cases like these, I dont really think there is a better solution.😐