How to split value in single quotes after specific string

unfortunately feedback is not clear. please rephrase and let us know in detail

  • what was done
  • what is failling
  • used sample data
    Thanks