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|
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|