json - JQ command to extract names into an array from a String

Question

Input is a document . I will get names in a String preceded by number

 {"doc": [
    {
      "cNo": "6222332 22450 32",
      "cNames": " 1 MANJSY JOAU 2 CHAFANH BINO",
      "cExpiry": "04/2025"
    },
    {
      "fields": 3,
      "documents": 1
    }
  ]}

The expected output is a name array sometime like shown below

 {"doc": [
    {
      "cNo": "6222332 22450 32",
      "cNameArray": [
                       "MANJSY JOAU",
                       "CHAFANH BINO"
                    ],
      "cExpiry": "04/2025"
    },
    {
      "fields": 3,
      "documents": 1
    }
  ]}

Answer 1

The question as I understand it has two main parts:

1. Converting a string with integer and non-integer segments to an array
2. Changing the key name from cNames to cNameArray

In the present context, the first part could be accomplished by:

.doc[0] |= (.cNames |= [splits(" *[0-9] *")][1:])

And the second could be accomplished by using with_entries, thus preserving the ordering of the keys:

.doc[0] |= (.cNames |= [splits(" *[0-9] *")][1:]
            | with_entries(if .key == "cNames" 
                           then .key = "cNameArray"
                           else . end) )