Payment References with Special Characters

[Hussein982]

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,

[Qiu · Accepted solution]

@Hussein982 
Maybe we can try Find and Replace and its eary to maintain.

[AkimasaKajitani]

Hi @Hussein982 

You can use RegEx_Match function at Formula tool.

IF REGEX_Match([Field1], ".*[\*#%@].*")=0
THEN "DO NOT USE" 
ELSE "USE" 
ENDIF

Result: