How to split a string and select nth part

Viewed 10468

I want to split a string using a colon as delimiter and select 2nd and 3rd part.

Table:

|asdsc:dcdes:dcd|
|dcfd:drfe:regf |

Expected output:

|dcdes|
|drfe|

and also third column:

|dcd |
|regf|
2 Answers
Related