web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How to remove unique I...

Microsoft Dynamics CRM (Archived)

How to remove unique ID numbers from name field after import?

(0) Share

Report

Report

Posted on by RachelS

70

Hello,

I wondered if anybody might be able to help me. I am new to crm 2011 and have currently been working at importing organisations (accounts) and contacts - I now have these importing correctly and did so by adding a unique ID number to the data before import - however this ID number shows within the organisation name - for example: Smith Family ID353 will appear in the organisation name field.visually (for invoices etc) it would be better if these ID numbers are removed from the names and I wondered if anybody could suggest how I go about doing this?

many thanks

Rachel

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

jlattimer 24,564 on at

Like (0)

Report
Copy link

Link copied!

Use Advanced Find to search and find all Account records that contain "ID*". Use the export feature (Excel icon) from the results to export and use the option at the bottom to make the data available to re-import. Also make sure the name field you want to edit is in the list of columns returned. Use Excel to remove the IDXXX values. There is probably a few ways to go about it. Create a new column for name and insert a formula like: =LEFT(A1,LEN(A1)-7)

Then go to Setting -> Data Management -> Import and import the saved file.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

Varsha deshpande 5

#2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans