Remove Substring
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
knnwndlm
8 - Asteroid
‎10-01-2024
11:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi SME,
I have a file that contains references to the state CA expressed in various forms as shown in column A in the attachment. I would like to use Fuzzy Match to see if I can remove anything that references the state. I had tried this with RegEx without full success. Fuzzy Match might be able to take care of this situation as future data could contain other variation of the state references.
Could you please provide me with the guideline on how to do this? I had used the Fuzzy Match tool before but this is a bit difference from what I could gather. FYI, column B is what I'm trying to get from column A.
Appreciate it.
Thanks,
kwl
Labels:
- Labels:
- Fuzzy Match
3 REPLIES 3
16 - Nebula
‎10-01-2024
01:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-08-2024
10:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Chris! Appreciate it!
nagakavyasri
12 - Quasar
‎10-08-2024
11:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
