New to data mining like this. My first post. Apologies if I did something wrong.

This is my data in the field. I cannot use length because I have different formats and lengths in the data.

[PICK] [LOCTN : 42-08-A-01]

What I want is

42-08-A-01

Tried these 3 select statements and they all came back the same way with the last right bracket.

SUBSTRING(table.field from '[LOCTN] : (.*?[^|:]]+)') AS test

split_part(wa.fx,':', 2) AS SUB1

(regexp_split_to_array(wa.fx, ':'::text))[2] AS STUFF

How can I get that last right bracket out?

42-08-A-01]