City Emp_Num_ID Cleveland 2164445437/FTTD/JAMES, TYLER/139561151 Tokyo 1261120379/FTTD/BOYD, ADAMS/14468140 Marakech 4049838896/FTTD/SMITH, TULY E/13956144 Houston 7980151429/FTTD/NEARY, HARTMAN/14215411
I'm trying to extract all digits after the third / with substring
select substr(Emp_Num_ID,/,10) as Emp_ID from Employee_M
sometimes we can have between 4 to 10 charterers after the third / so I chose 10 for the length.
any idea how to fix that.