how to use substring with a delimiter

0 votes

1 answer

3253 views

Employee_M

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.

Asked by Driven (15 rep)

Apr 17, 2019, 08:02 PM
Last activity: Dec 24, 2021, 03:41 PM

how to use substring with a delimiter

Related Questions