CODEWITHSUNDEEP
sqldatabaseregex-groupteradata-sql-assistantteradatasql
Ankush Gondane
Ankush Gondane

Reputation: 11

Teradata SQL assistant

How to perform below operation using teradata,

Input string- 'data1 data2 (1) (Ab-123)'

output required- Ab-123

So basically I want data from last bracket.

Upvotes: 0

Views: 191

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269943

This looks like a regular expression:

select regexp_substr('data1 data2 (1) (Ab-123)',
                      '[(]([^)]*)[)]$'
                     )

Upvotes: 1

Related Questions