need to obtain 5-character code (translated into upper-case) following the fourth comma in the table
I want to write a teradata SQL to retrieve the 5th digit value followed by 4th comma and needs to translate it to upper case
and if the string does not contain any comma OR less than 4 commas, then the query should come back with nulls.
see below wbp98 in 1st row after 4th comma and needs to translate to uppercase x1vqm-2nd row after 4th comma needs to translate to uppercase VLHHV-3rd row after 4th comma needs to translate to uppercase
ex rows in a colomn P09-2001365000042108792,09262006,08022006,,wbp98,wbp98,,22,4,6,2,20,Landscaping,2,,1,2,,3,,5,2,,2,2,2,2,2,,-1,0,1,1,,0,0,2,,,2,,,2,559464948,545804394,,,,CM-N/C