I have some string values in column like below
hel_some_data
h_some_data_more_data
hello_some_more_data_data
I need output like below
hel_some data
h_some data more data
hello_some more data data
basically I want to replace ‘_’ with ‘ ‘ except first occurance
I am trying to use regex replace but unable to find how to give the position, I have found one syntax on documentation where it looks like providing the position by code from documentation itself not working, I am trying below example for documentation.
SELECT REGEXP_REPLACE('the fox', 'FOX', 'quick brown fox', 1, 'i');
But it says function not found.
Any help, highly appreciated,
Thanks,