Add new line when printing data using jsonpath
2 min read | by Jordi Prats
When we print values using jsonpath we'll get all the values in a single line (actually, it won't even bother adding the newline character at the end of the list):
$ kubectl get ns -o jsonpath='{ .items[*].metadata.name }' default dynamodb-operator ec2-operator iam-operator kube-node-lease kube-public kube-system local-path-storage testvault To be able to add the new line character after each item we'll nee to iterate over it using range and append {"\n"} after each item:
$ kubectl get ns -o jsonpath='{ range .items[*]}{.metadata.name}{"\n"}{end}' default dynamodb-operator ec2-operator iam-operator kube-node-lease kube-public kube-system local-path-storage testvault It's not limited to new lines, so we can use it to make it output some custom format as well. In the following example we are printing the creation timestamp using a comma as delimiter:
$ kubectl get ns -o jsonpath='{ range .items[*]}{.metadata.name}{","}{.metadata.creationTimestamp}{"\n"}{end}' default,2023-05-12T21:15:47Z dynamodb-operator,2023-05-29T21:24:26Z ec2-operator,2023-05-16T21:58:59Z iam-operator,2023-06-01T19:49:21Z kube-node-lease,2023-05-12T21:15:45Z kube-public,2023-05-12T21:15:45Z kube-system,2023-05-12T21:15:45Z local-path-storage,2023-05-12T21:15:50Z testvault,2023-05-12T21:17:07Z Posted on 06/06/2023