<div>
<div class="content wysiwyg-content">
Due to a mistake made by one of our programmers we are in a situation where there are several users who have a space &quot;&nbsp;&quot; in some of their AD fields. Most notably their cell phone field. What the programmer did was inadvertently pass a space &quot;&nbsp;&quot; character rather than a null value. What I would like to do is find a way to clean this up. <br />
<br />
I have tried doing a query in ADUC to find users where the mobile number starts with a space &quot;&nbsp;&quot; but it returns all users in AD. <br />
<br />
Is there a way to search for a space &quot;&nbsp;&quot; character in a query. <br />
<br />

</div>
</div>


Due to a mistake made by one of our programmers we are in a situation where there are several users who have a space " " in some of their AD fields. Most notably their cell phone field. What the programmer did was inadvertently pass a space " " character rather than a null value. What I would like to do is find a way to clean this up. 

I have tried doing a query in ADUC to find users where the mobile number starts with a space " " but it returns all users in AD. 

Is there a way to search for a space " " character in a query. 



Searching for a space in AD fields

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).