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.