SOLVED
Regex
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
hi2019
8 - Asteroid
‎08-12-2024
06:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi
what tool can I use to identify REGEX_Replace([Payee addr 2], "[^\u\d&\s-]+", " ")
thanks
Solved! Go to Solution.
Labels:
- Labels:
- Reporting
4 REPLIES 4
Raj
16 - Nebula
‎08-12-2024
06:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@hi2019
use formula tool.
‎08-12-2024
06:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to modify but I need to first understand this one as well- multi field formula -
REGEX_Replace([_CurrentField_], "[,!\(\)#';\\/@]", ' ')
Raj
16 - Nebula
‎08-12-2024
06:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@hi2019
if you use multi field formula then this will update same formula on multiple fields.
and if you want to apply on single field use formula tool.
hope this helps.
Raj
16 - Nebula
‎08-13-2024
04:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@hi2019
is this solved?
if not you can add an input and i can help with workflow.
