Is there a function similar to split_part, json_extract_scalar?

[dulu]

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

split_part,

json_extract_scalar

are not?

[Ankush]

pyspark.sql.functions.

get_json_object

(col, path)[source]

Extracts json object from a json string based on json path specified, and returns json string of the extracted json object. It will return null if the input json string is invalid.

[Kaniz]

Hi @Du Lu​, We haven’t heard from you since the last response from @Ankush Jadhao​​​, and I was checking back to see if his suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

[dulu]

Thanks @Ankush Jadhao​  for answer, I tried but only returns the first result in the cell. They seem to only take the first character with the correct result. I need out put like the table below.

I have the following input:

 

I am looking for a way to split the characters in the item_order_detail column into 2 columns itemID and itemName. As below output table uses SQL function in databricks with spark_sql version 3.2.1.