SOLVED
Payment References with Special Characters
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
Hussein982
8 - Asteroid
03-04-2021
05:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All:
I have an invoice and payment file and I need to create a computed field that flags for special characters and use FIND function to search for “*,” “#,” “%,” “@” and “DO NOT USE.”
How can I customize this to my requirement.
Appreciate the help in advance.
Cheers,
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
2 REPLIES 2
21 - Polaris
03-04-2021
05:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Hussein982
Maybe we can try Find and Replace and its eary to maintain.
17 - Castor
03-04-2021
09:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Hussein982
You can use RegEx_Match function at Formula tool.
IF REGEX_Match([Field1], ".*[\*#%@].*")=0
THEN "DO NOT USE"
ELSE "USE"
ENDIF
Result:
