I would like to know any if there is a function to find the pattern in a string, In SQL Server they used PATINDEX function to retrive a 5 char alphanumeric from a string. Below is the data set
Input Expected output
All of America A1234 A1234
In sql server they used SUBSTRING(COlumn, PATINDEX('%[a-z][0-9][0-9][0-9][0-9]%', column), 5).
What's your Teradata release?
TD14 implements Regular Expressions: