I’m trying to extract different parts of an string input based on the occurrence of a character. But whatever I do is not working.

select 'abc_def_ghij_20230108100000_20230108100000_20240517105347', substring('abc_def_ghij_20230108100000_20230108100000_20240517105347', 0, /^[^_]*/)

I need to extract each of the parts from the input string where the underscore _ appears.

How to do this in Cosmos DB?