Conditional Concat with space

[binh.le]

https://docs.couchbase.com/server/5.5/n1ql/n1ql-language-reference/condfununknown.html

You can use the conditional functions to test the content of the ‘Middle’ field before the concat.