Split page titles containing hyphens into separate values

Scenario

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

For example, you have many pages and the title of the page has the following format:

"Meeting-ID - Meeting-Title"

For example:

12345 - Meeting with NASA
23456 - Meeting with Dolby
34567 - Meeting with Atlassian

With the use of the Collection Supplier and Text Supplier, you can split the page titles with hyphens to break the Meeting ID and Meeting title into two different columns.

Result

Recipe

Apps	Reporting for Confluence Server & Data Center

Apps	Reporting for Confluence Server & Data Center
Level	Easy
Estimated time	10 minutes
Macros	Content Reporter, Report Column, Report Info, Report Table, Text Sort
Suppliers	Collection Supplier, Content Supplier, Date Supplier, Text Supplier, User Supplier

Storage format

You can copy and paste this code into the Confluence Source Editor:

<ac:structured-macro ac:macro-id="84217c92-e5d7-4cc7-93da-17ca44bdff03" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="b097ce96-aeb0-475b-b3ba-6ee46166a4c5" ac:name="content-reporter" ac:schema-version="1">
      <ac:parameter ac:name="types">page</ac:parameter>
      <ac:parameter ac:name="scope">Meeting Notes &gt; Children</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="4ce3d743-c0ef-4a66-a4c5-27ff4e0fec81" ac:name="text-sort" ac:schema-version="1">
            <ac:parameter ac:name="">title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="0cf0354e-ac50-4a76-be26-e36beb9dc7b1" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Meeting ID</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="4e836aa8-bf1a-48c8-a17c-940f0f4abb76" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">content:title &gt; text:split with - &gt; collection:1</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="9e28024b-5e39-4503-baa6-f7b3c2e3264f" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Meeting Title</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="ae0a35a2-9633-40ba-8e3f-d203c1ee38b1" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">content:title &gt; text:split with - &gt; collection:2</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="814e3d66-e6fa-4249-98a7-5ada0e2d8c42" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Created Date</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="7a3dc562-4c60-409a-8f88-4333e74347a6" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">content:creation date &gt; yyyy-MM-dd</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="94d6cb4e-1ab1-4f03-8c25-b8d884cbcf4d" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Creator</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="3fb0ed4d-62b5-4a13-8b85-e2c5928a80a9" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">content:creator &gt; full name</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
  <br />
</p>
<p class="auto-cursor-target">
  <br />
</p>

Macro structure

You can recreate the example in the editor view:

Steps

Create a Report Table macro.
Within Report Table macro, create a Content Reporter macro.
For Content Reporter macro, set the following parameters:
Types: page
Scope: Meeting Notes > Children
Within Content Reporter macro, create a Text Sort macro and insert "title" in Key parameter.
Within Report Table macro, under Content Reporter macro, create four Report Column macro.
Set the first Report Column macro's Title to "Meeting ID" and add a Report Info macro within it.
Set the Report Info macro's Key to "content:title > text:split with - > collection:1".
Set the second Report Column macro's Title to "Meeting Title" and add a Report Info macro within it.
Set the Report Info macro's Key to "content:title > text:split with - > collection:2".
Tick Link To Item.
Set the third Report Column macro's Title to "Created Date" and add a Report Info macro within it.
Set the Report Info macro's Key to "content:creation date > yyyy-MM-dd".
Set the forth Report Column macro's Title to "Creator" and add a Report Info macro within it.
Set the Report Info macro's Key to "content:creator > full name".