This can be done by jolt like this: [ { "operation": "modify-overwrite-beta", "spec": { "issued_year": "=substring(@(1,issued),0,4)", "issued_month": "=substring(@(1,issued),5,7)", "issued_day": "=substring(@(1,issued),8,10)", "issued_hour": "=substring(@(1,issued),11,13)", "issued_minute": "=substring(@(1,issued),14,16)", "issued_second": "=substring(@(1,issued),17,19)" } }, { "operation": "shift", "spec": { "issued_year": "issued_year", "issued_month": "issued_month", "issued_day": "issued_day", "issued_hour": "issued_hour", "issued_minute": "issued_minute", "issued_second": "issued_second" } } ] ... View more