DURING EXCEL DATA IMPORT - LINE FEEDS CONVERTED TO _X000D_

(0) Share

Report

Posted on by Himanshu Kamboj

421

Hi ,

As I am Importing the data into dynamics using excel and after the imports this _x000d_ automatically added into the data, this obviously impacts the content.

So I want to remove these _X000D_ from my records. As I am importing the email activity data and I am facing this issue into the Notes Field.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Wahaj Rashid 11,321 on at

Like (0)

Report
RE: DURING EXCEL DATA IMPORT - LINE FEEDS CONVERTED TO _X000D_

Hi,

Thank you for your query.

This is happening because of carriage return (next line) in the Email Body when you import from Excel.

To fix this, you have to remove the carriage return from the excel file, using one of the following formulas:

Replace([field],CharFromInt(13),"")

If you need the next line:

REGEX_REPLACE([field],"_x000D_","") - (this will remove the carriage return)

REGEX_REPLACE([field],"_x000D_", CharFromInt(13)) - this will replace the "_x000D_" with Carriage Return Char (which is Char(13)).

I would suggest you get the HTML email body (instead of plain text so you do not run into this issue) or avoid using Excel import.

Another approach is to update the data in Dynamics 365 after your import it (replace the "_x000D_" using a plugin or webapi).

Was this reply helpful? Yes No