# Set Max length on an attribute

**URL:** <https://developer.sailpoint.com/discuss/t/set-max-length-on-an-attribute/10142>\
**Category:** SHF Discussion and Questions\
**Tags:** transforms\
**Created:** [April 11, 2023, 5:31pm UTC](https://developer.sailpoint.com/discuss/t/set-max-length-on-an-attribute/10142 "2023-04-11T17:31:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![krigney](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/krigney/32/772_2.png) [@krigney](https://developer.sailpoint.com/discuss/u/krigney)\
**Post date:** [April 11, 2023, 5:31pm UTC](https://developer.sailpoint.com/discuss/t/set-max-length-on-an-attribute/10142/1 "2023-04-11T17:31:06Z")

</div>

So we have a database that can’t increase a column width so we need to short the attribute length when sending to that Database. Is there anyway to do this with a transform?

---

<div class="post-metadata">

**Author:** ![ethompson](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/ethompson/32/17298_2.png) [@ethompson](https://developer.sailpoint.com/discuss/u/ethompson)\
**Post date:** [April 11, 2023, 6:56pm UTC](https://developer.sailpoint.com/discuss/t/set-max-length-on-an-attribute/10142/2 "2023-04-11T18:56:22Z")

</div>

Substring may be what you are looking for.

> **[IdentityNow Transforms - Substring](https://community.sailpoint.com/t5/IdentityNow-Wiki/IdentityNow-Transforms-Substring/ta-p/180573)**
>
> Overview A substring transform can be used to get the inner portion of a string that is passed into the transform. You can use substring to get the first n characters, or to get a set number of characters within the middle of a string. Other...

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [July 19, 2023, 2:24pm UTC](https://developer.sailpoint.com/discuss/t/set-max-length-on-an-attribute/10142/3 "2023-07-19T14:24:46Z")

</div>


