# Alarm Status Table - Formatting Columns to extract certain data (from a UDT)

**URL:** <https://forum.inductiveautomation.com/t/alarm-status-table-formatting-columns-to-extract-certain-data-from-a-udt/108833>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 23, 2025, 2:34pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-formatting-columns-to-extract-certain-data-from-a-udt/108833 "2025-07-23T14:34:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jack.t](https://avatars.discourse-cdn.com/v4/letter/j/e79b87/32.png) [@jack.t](https://forum.inductiveautomation.com/u/jack.t)\
**Post date:** [July 23, 2025, 2:34pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-formatting-columns-to-extract-certain-data-from-a-udt/108833/1 "2025-07-23T14:34:03Z")

</div>

Using Perspective:

I want the Display Path from the out of box alarm status table to only show a specific value from the Tag it uses.

My UDT's are all defined and set up so the tags pull in the correct data, my issue is the display path is messy and I only want a certain part - surely there is a concatenate feature?

I have tried all the built in {} UDT Parameters but none of them give me exactly what I want..

Full Path: CLR105/CV/Fault/EncoderFault/EncoderFault  
Desired Outcome: CLR105\_CV

Using the UDT Parameters:  
{InstanceName} = Fault  
{ParentInstanceName} = Fault  
{PathtoParentFolder} = CLR105/CV/Fault  
{PathToTag} = CLR105/CV/Fault/EncoderFault  
{RootInstanceName} = CV  
{TagName} = Encoder Fault

Is there any expression scripting I can use that will return a concatenated version so I can get my desired outcome?

I tried adding a new custom column called AssetName which added fine but the expression binding to retrieve the data from the DisplayPath didn't work.

Many thanks in advance.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/9/d958124a4c955cfab589a7b08b746a54ea7a8366.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/a/9a66bc49da4f659d0881caee6405081fc242a6fc.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/0/90216ddf52981c4579be1db905a903502a719fa6.png)

---

<div class="post-metadata">

**Author:** ![Bushmatic](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bushmatic/32/87014_2.png) [@Bushmatic](https://forum.inductiveautomation.com/u/Bushmatic)\
**Post date:** [July 23, 2025, 3:01pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-formatting-columns-to-extract-certain-data-from-a-udt/108833/2 "2025-07-23T15:01:34Z")

</div>

> [@jack.t](#):
>
> I tried adding a new custom column called AssetName which added fine but the expression binding to retrieve the data from the DisplayPath didn't work.

Can you show the expression binding you tried?

---

<div class="post-metadata">

**Author:** ![jack.t](https://avatars.discourse-cdn.com/v4/letter/j/e79b87/32.png) [@jack.t](https://forum.inductiveautomation.com/u/jack.t)\
**Post date:** [July 24, 2025, 3:09pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-formatting-columns-to-extract-certain-data-from-a-udt/108833/3 "2025-07-24T15:09:15Z")

</div>

I finally got it working but it took way longer than I'd care to share.. thank you for your interest I appreciate it - leave the screens for a few hours and come back to it fresh most of the time works for me..

split({PathToParentFolder}, "/")[0] + "\_" + {RootInstanceName}

Is how I've managed it.