2 Replies Latest reply on Mar 17, 2010 6:59 AM by Jamie Cannon

    Truncating Imported data

    Jamie Cannon ITSMMVPGroup

      Is there a way in the Data Connections custom LDAP filter OR in the data import information to truncate information that is imported?  We want to import Canonical-Name into a field named "Domain" within the User account but we only want the information before the first period.  For example:


      Canonical-Name = domainname.root.something.org/ManagedOffice/Location/OU


      I just want the "domainname" and nothing more.  Is that possible?