Is there a function similar to split_part, json_extract_scalar?

dulu
New Contributor III

I am using spark_sql version 3.2.1. Is there a function that can replace

split_part,

json_extract_scalar

are not?