Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Search for Wildcard sy...
Microsoft Dynamics CRM (Archived)

Search for Wildcard symbol

(0) ShareShare
ReportReport
Posted on by braddels 145

Hi Everyone,

We are currently rolling out CRM for the first time in my company and our data is seriously unclean, in fact it is offensive. We have have terms like ***Cash on delivery*** in the address field, but each of our account managers (about 50 round the country) has their own style for these terms, but all, usually, contain an asterisk. What i want to know, that i haven't found an answer for on the web or from our CRM company, is can i do an advanced find for an asterisk? I tried doing it like i would in excel (~*), this initially worked but two seconds later cleared the search to show no results.

What i ultimately want to do is create a dynamic list for any address field that contains an asterisk so we can keep on top of our data cleansing (which has been agreed to be done after the final data load and not before) and potentially incentivise account managers for having clean data.

Any help would be greatly appreiciated.

Thanks

Brad

*This post is locked for comments

  • braddels Profile Picture
    braddels 145 on at
    RE: Search for Wildcard symbol

    Thanks Ben

  • braddels Profile Picture
    braddels 145 on at
    RE: Search for Wildcard symbol

    Hi Aileen,

    Thanks for this, i think it will have to be done it excel. I didn't think it was possible as i couldn't find an answer anywhere else, but thought i would check.

  • Verified answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at
    RE: Search for Wildcard symbol

    Hi Brad, Ben,

    I have tried a lot of characters including ** as well.

    including "*"

    Including [*]

    Still no works.

    Maybe you should use Export to Excel to find dirty data for the sake of data cleaning.

    You can use formula maybe, but the easiest way is using CTRL + F

    ~* is the keyword

    Thanks.

  • Verified answer
    Hosk Profile Picture
    Hosk on at
    RE: Search for Wildcard symbol

    I have just tried this

    I changed account name to ***

    I then did a search where account name contains *

    it returned all the rows

    I don't think there is a way to search for * using advanced find and the only way I can think of finding these is by exporting them to excel and removing these asterisks or changing them to another character you can find with advanced find.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,886 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,768 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans