Skip to Main Content

Splitting a string into five columns (some can be null)

Gor_MahiaSep 9 2022

Hi,
ive a string like the below:
i. 'Y,MN,,1,',
ii. 'Y,TX,500,T55,james@yahoo.com',
iii. 'abcd,123,defoifcd,87765'

Now iam trying to split these "," delimited strings into columns which can be 5 or more.
Iam using Frank's suggestion in the link below but it doesn't work correctly:
https://community.oracle.com/tech/developers/discussion/2348338/divide-the-comma-separated-string-into-columns
you can see my output below
image.png
any suggesting is appreciated.
Oracle 11g
thanks

This post has been answered by Frank Kulash on Sep 9 2022
Jump to Answer
Comments
Post Details
Added on Sep 9 2022
5 comments
62 views