Regex Split content between parenthesis ()

I have a string in that contains an ID-Number between parenthesis. The string looks like this:

 LOC 2: Name VIRGIL (12345678/09876) entered using card 1234.

LOC 3: Name TIGER (23456789/98765) entered using card 3456.

LOC 4: Name COLE (34567890/87654) entered using card 5678.

I need to extract the  ID-Number into a new column.

I would be grateful for any suggestions.

 

tC/.

I would use the string replacer, with regex option set.

use search string:

.+\((.+)\).+

For replacement use:

$1

 

simon.