The REGEX Expression and REGEX Replacement Value columns allow you to build complex editing expressions, and have values found by the expression either removed or replaced. 


For example, if you have strings in your Company Name column that contain round brackets i.e. "(" and ")" that you wish to remove:



...use the following expression in the REGEX Expression column:


([()])


...and leave the REGEX Replacement Value cell empty. Notice the "(" and ")" have now been removed from the Company Name:




Examples of Regex which can be used to remove characters:


Regex

Description

(^\"|^\')

remove " or  ' at the beginning of text

([A-Z]?[a-z]?)

remove all english letters

(^\[a-z]|\s)

remove all lowercases or space at the beginning of text 

(^\*\d+)

remove all numbers

(\:|\;|\.|\,|_)

remove the ":" or  ";" or "." or  "," from the text

\+|-|\*|\=|\/

remove the basic mathmatical operators(+,-,*,/,=)

(!|@|#|\$|%|&|\?)

remove the special characters

(\(|\)|\[|\]|\{|\}|\<|\>)

remove the any brackets

(@)(.*?)$

remove the at-sign and domain of email

^([a-zA-Z]*?)(?=:\/\/)(:\/\/)

remove the url schema of website

(?<=.)([0-9])*$

remove the fractional part of decimal

^\+\d{2}

remove the country code of phone number

(\.|\,|\!|\@|\#|\`|\~|\$|\%|\^|\+|\/|\-|\&|\*|\(|\)|_|\+|-|\=|\[|\]|\{|\}|\:|\"|\;|\'|\,|\.|\/|\<|\>|\?)

remove all special characters