---
title: "Split page titles containing hyphens into separate values"
canonical: "https://support.appfire.com/space/RFC/477333905/Split%20page%20titles%20containing%20hyphens%20into%20separate%20values"
format: markdown
---
> Macro (aura-html)

## Scenario

This recipe shows you how to split page titles containing hyphens into separate values and use them in separate columns of a table.

You can copy and paste this code into the target Confluence page:

```
{
    "cql": "type=page and title ~ \"Meeting\"",
    "filters": [],
    "expansions": "content.history",
    "reportInfos": [
        {
            "id": "2a699b1b-899f-4021-9b6e-9da7af1248e8",
            "type": "text",
            "title": "Meeting ID",
            "value": "content.id",
            "template": "{\"version\":1,\"type\":\"doc\",\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{% assign temp = content.title | split: ' - ' %} {{ temp[0] }}\"}]}]}"
        },
        {
            "id": "850c5abf-41a3-4a22-8562-b4cd39033f10",
            "type": "text",
            "title": "Meeting Title",
            "value": "content.id",
            "template": "{\"version\":1,\"type\":\"doc\",\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{% assign temp = content.title | split: ' - ' %} {{ temp[1] }}\"}]}]}"
        },
        {
            "id": "d21fa09b-811f-4fe0-98a5-0ef5545e1361",
            "type": "text",
            "title": "Created Date",
            "value": "content.id",
            "template": "{\"version\":1,\"type\":\"doc\",\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{% assign temp = content.history.createdDate | split: 'T' %} {{ temp[0] }}\"}]}]}"
        },
        {
            "id": "1cca57bb-7258-4a36-b6c2-f1a4828a64a5",
            "type": "basic",
            "title": "Creator",
            "value": "content.history.createdBy.displayName",
            "template": "{\"type\":\"doc\",\"version\":1,\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{{ content.history.createdBy.displayName }}\"}]}]}"
        }
    ]
}
```

## Result

![image](media://2e28ab59-e91d-4758-9716-2a074841852b)

## Recipe

| Apps | Reporting for Confluence Cloud |
| --- | --- |
| Level | Easy |
| Estimated time | 5 minutes |

## Notes

This recipe is part of the Reporting built-in templates. You can load it into your page by [using the templates feature](https://appfire.atlassian.net/wiki/spaces/RFC/pages/477333100).

![reporting_templates.png](media://36a50519-3609-4c20-9c19-e6dd28352fc7)

The report is limited to 200 results by default. If you want to view more results, you can enable **Get all results** below the search box.

## Caveats

- Hyperlinking is not yet implemented.
- Relies on Liquid split function to convert ISO 8601 date time to `YYYY-dd-mm` format.