CODEWITHSUNDEEP
dynamics-crm-2011dynamics-crm
Ravi Yenugu
Ravi Yenugu

Reputation: 3898

Leading White Space when importing CRM Data

I have updated Contact Entity field using Excel import.Fieldname:FieldA which is a text box. The import was "Successful" ,except I find the leading white space in FieldA now and I am not able to even delete them manually.

I tried to export them and used the trim function in Excel and reimported them but it still comes up with a leading whitespace. (There are approx. 100 records)

Any Ideas?

Upvotes: 1

Views: 380

Answers (1)

MarioZG
MarioZG

Reputation: 2087

For some reason, CRM doesn't recognize removing space as a change.

I have used two step workaround for this:

  • modify field by removing space and adding . (dot) at the beginning of the field
  • import
  • remove . (dot)
  • import

it's bit messy but worked for me.

Upvotes: 1

Related Questions