The REGEX Substring Value allows you to add a REGEX command which the results will then be placed into a seperate column.


For example, if you wanted to split out the numbers within an address line, you could use the REGEX expression > ^\d+  (as shown below)





By applying the REGEX, you will see below how a new column has been created "Address1_Split_Regex_1" which now contains the results from the REGEX expression.




Examples of Regex which can be used for splitting:


Regex

Description

(?<=-)\d*$

parsing second numbers of zip code

^[0-9]{5}^\d*

parsing first numbers of zip code

(?<=@)(.*?)(?=\.)

parsing email type

^(.*?)(?=@)

parsing email user id

(?<=:\/\/)([a-zA-Z0-9.])+

parsing domain name of website url

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

parsing url schema of website url(http or https)

^[0-9,]+

parsing integer part of balance

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

parsing fractional part of balance

^\+\d{2}

parsing coutry code of phone number

\d{6}$

parsing Subscriber number of phone number

^\d{1,2}(?=:)

parsing hour value from time

([a-z]m|[A-Z]M)

parsing am or pm of time