# Attribute spliting in Active Directory

**URL:** <https://developer.sailpoint.com/discuss/t/attribute-spliting-in-active-directory/221441>\
**Category:** IIQ Discussion and Questions\
**Tags:** attributes, active-directory, identityiq\
**Created:** [September 4, 2026, 9:10am UTC](https://developer.sailpoint.com/discuss/t/attribute-spliting-in-active-directory/221441 "2026-09-04T09:10:04Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Harsha\_Vardhan\_Bondi](https://avatars.discourse-cdn.com/v4/letter/h/f0a364/32.png) [@Harsha\_Vardhan\_Bondi](https://developer.sailpoint.com/discuss/u/Harsha_Vardhan_Bondi)\
**Post date:** [September 4, 2026, 9:10am UTC](https://developer.sailpoint.com/discuss/t/attribute-spliting-in-active-directory/221441/1 "2026-09-04T09:10:04Z")

</div>

I am using the sailpoint iiq 8.4 and i have one delimeted file and Active directory application so in the delimeted file i have the attribute location which contains the big data where the whole location should split into the part which are attributes of the Active directory for example location is S15street-Queens-NewYork-500085 so it should fall in active directory like

streetAddress -----------\> S15street-Queens  
st --------------\>S15street  
l ---------------\>NewYork  
postalCode----------\>50000591

i did the authoritative csv file on boarded when ever i do the manage user access and give the entitlement the identity gets the link of active directory application by create operation but the values of streetAddress, st, l, postalCode should reflecting  
in the active directory how to get that in the sailpoint]\*

for example see the attribute in the target application

 ![image](https://global.discourse-cdn.com/sailpoint/original/3X/2/2/221f20aebfa723de1d3200dfdfe70687e62bcea5.png)  
;

like this we have the attributes as streetAddress,st,l,postalCode

---

<div class="post-metadata">

**Author:** ![neel193](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/neel193/32/34038_2.png) [@neel193](https://developer.sailpoint.com/discuss/u/neel193)\
**Post date:** [September 4, 2026, 9:35am UTC](https://developer.sailpoint.com/discuss/t/attribute-spliting-in-active-directory/221441/2 "2026-09-04T09:35:52Z")

</div>

@Harsha_Vardhan_Bondi Please navigate to Administrator Console and check the Provisioining Transaction to check if you see the AD transaction and all the these attributes being passed from IIQ to AD.

---

<div class="post-metadata">

**Author:** ![punna0001](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/punna0001/32/42011_2.png) [@punna0001](https://developer.sailpoint.com/discuss/u/punna0001)\
**Post date:** [September 4, 2026, 10:04am UTC](https://developer.sailpoint.com/discuss/t/attribute-spliting-in-active-directory/221441/3 "2026-09-04T10:04:22Z")

</div>

Welcome to the community, Harsha.

You can do this in the AD Create Account provisioning policy. [SailPoint Documentation](https://documentation.sailpoint.com/connectors/identityiq8_4/active_directory/help/integrating_active_directory/provisioning_policy.html)

First, make sure the CSV `location` value is available as an Identity attribute. If it currently exists only on the delimited-file account, map it under Identity Mappings, then run Identity Refresh with Refresh identity attributes selected.

You should then be able to read it as:

```auto
identity.getStringAttribute("location")

```

In the AD Create Account policy, add:

```auto
streetAddress
l
st
postalCode

```

Create one FieldValue rule with the following logic, then select that same rule as the value source for all four fields:

```auto
String location = identity.getStringAttribute("location");
if (location == null) return null;

String[] parts = location.split("-", -1);
if (parts.length != 4) return null;

String name = field.getName();

if ("streetAddress".equals(name)) return parts[0].trim();
if ("l".equals(name)) return parts[1].trim();
if ("st".equals(name)) return parts[2].trim();
if ("postalCode".equals(name)) return parts[3].trim();

return null;

```

Assuming your format is:

```auto
Street-City-State-PostalCode

```

then:

```auto
S15street-Queens-NewYork-500085

```

produces:

```auto
streetAddress = S15street
l = Queens
st = NewYork
postalCode = 500085

```

In AD, `l` is City/Locality and `st` is State/Province. [Microsoft Learn](https://learn.microsoft.com/en-us/windows/win32/ad/address-book-properties)

Finally, test with a user who does not already have an AD account. Check the provisioning request and confirm these four values are present in the Create request.

---

<div class="post-metadata">

**Author:** ![neel193](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/neel193/32/34038_2.png) [@neel193](https://developer.sailpoint.com/discuss/u/neel193)\
**Post date:** [September 13, 2026, 7:19pm UTC](https://developer.sailpoint.com/discuss/t/attribute-spliting-in-active-directory/221441/5 "2026-09-13T19:19:12Z")

</div>

@Harsha_Vardhan_Bondi Is this issue resolved? If yes, could you please share how did you make it work to help fellow sailors having similar issue.

---

<div class="post-metadata">

**Author:** ![Harsha\_Vardhan\_Bondi](https://avatars.discourse-cdn.com/v4/letter/h/f0a364/32.png) [@Harsha\_Vardhan\_Bondi](https://developer.sailpoint.com/discuss/u/Harsha_Vardhan_Bondi)\
**Post date:** [September 17, 2026, 9:11am UTC](https://developer.sailpoint.com/discuss/t/attribute-spliting-in-active-directory/221441/6 "2026-09-17T09:11:39Z")

</div>

[Split Attribute in Active directory.docx](https://developer.sailpoint.com/discuss/uploads/short-url/1d3VkZTrukJZtP18w9dSm18SSex.docx) (84.1 KB)

here is the documentation which i have done according to my knowledge

---

<div class="post-metadata">

**Author:** ![neel193](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/neel193/32/34038_2.png) [@neel193](https://developer.sailpoint.com/discuss/u/neel193)\
**Post date:** [September 18, 2026, 5:44am UTC](https://developer.sailpoint.com/discuss/t/attribute-spliting-in-active-directory/221441/7 "2026-09-18T05:44:30Z")

</div>

@Harsha_Vardhan_Bondi Did it work in your case and have you tested all valid use cases?

---

<div class="post-metadata">

**Author:** ![Harsha\_Vardhan\_Bondi](https://avatars.discourse-cdn.com/v4/letter/h/f0a364/32.png) [@Harsha\_Vardhan\_Bondi](https://developer.sailpoint.com/discuss/u/Harsha_Vardhan_Bondi)\
**Post date:** [September 22, 2026, 10:57am UTC](https://developer.sailpoint.com/discuss/t/attribute-spliting-in-active-directory/221441/8 "2026-09-22T10:57:04Z")

</div>

Good Afternoon SIr,

Yes it worked in my case