i have a json file like the schema below and want to split the value of the key 'adress' by a character (for example a comma):
{
"id": 123,
"name": "James",
"adress": "Oxford Street,21,London,England"
}
and convert it to the following (-> split the adress field by comma into these fields):
{
"id": 123,
"name": "James",
"street": "Oxford Street",
"house number": "21",
"city": "London",
"country": "England"
}