Regex for extracting a particular string in the re…

Need to extract a particular alphanumeric string from the records of a column.Add a new column in the report for the extracted values and add to the visual.

For Example:  Swift/Bic:STRULM23L is the string to be extract from every records of a column which has many alphanumeric values and add it to the another new column.This Swift/Bic:STRULM23L differs in every record as BIC/Swift:STRULM23 or Swift/Bic Code :VBTYSI890 ETC…