This is example of my array
What I would like to do is to extract first 8 digit of app_hs and add it back to array as hs8
[
{
"app_no": "G7605001503",
"app_status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "On process"
},
"app_hs": "1221310000",
"app_scheme": "XSEAN",
"app_model": "XIACE",
"app_part_name": "XLEMENT , XIR XEFINER",
"app_xxx_percent": "95.0788"
},
{
"app_no": "G7605002031",
"app_status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "On process"
},
"app_hs": "9911220000",
"app_scheme": "XSEAN",
"app_model": null,
"app_part_name": "XING, SNAX",
"app_xxx_percent": "61.8968"
}
]
This is the result I expected to be
[
{
"app_no": "G7605001503",
"app_status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "On process"
},
"app_hs": "1221310000",
"app_scheme": "XSEAN",
"app_model": "XIACE",
"app_part_name": "XLEMENT , XIR XEFINER",
"app_xxx_percent": "95.0788",
"hs8":"12213100"
},
{
"app_no": "G7605002031",
"app_status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "On process"
},
"app_hs": "9911220000",
"app_scheme": "XSEAN",
"app_model": null,
"app_part_name": "XING, SNAX",
"app_xxx_percent": "61.8968",
"hs8":"99112200"
}
]
I try to do substring extraction but got error. Please give some suggestion...
