HTML to Plain Text Conversion Issue

(0) Share

Report

Posted on by jmillsjmills

Hello,

I have been working on a custom workflow where I move the content of an email description field to a case description field, as I effectively convert an email to a case. Have had the common issue where this then originally comes back in HTML formatting with endless tags which then make the case field impossible to read.

With Jason Lattimer's magnificent string workflow solutions, I have converted the field content so it would read something like "Dear Person, Here is my email from Person". His workflows leave in line breaks deliberately, but is there any simple way I could then turn this into:

"Dear Person

Here is my email

from Person"

Could I find and replace the " " to something else for example that would force this? I had followed this description but it just replaces the with double spaces, rather than forcing new lines..

https://community.dynamics.com/crm/b/meganwalker/posts/removing-html-from-email-description-record-creation-rules

Any help would be most appreciated! I am rather new to Dynamics!

Thanks,

Jon

I have the same question (0)

All responses (16)

Answers (1)

Suggested answer

T.I.A 1,760 on at

Like (1)

Report

HI Jmills

You should be able to replace the breaks with \n.

Example: string html = "Dear Person Here is my email from Person";

string newString = html.Replace(" ", "\n\n");

case["example_description"] = newString;

service.Update(case);

I've tried this with a multiple line of text field and it works fine. Let me know how you go.

Was this reply helpful? Yes No
jmillsjmills 31 on at

Like (0)

Report

Amazing. Thank you for your reply! Sorry to be silly - where could I actually implement this within the workflow user interface of Dynamics?

Was this reply helpful? Yes No
T.I.A 1,760 on at

Like (0)

Report

Ah you can't unless you implement this part in a custom workflow activity via C#.

Was this reply helpful? Yes No
Suggested answer

cloflyMao 25,210 on at

Like (0)

Report
Hi jmill,

That's because the workflow tool you use will insert all contents directly as text without characters conversion even if we can replace all br tags with our own symbols by regex.

I suggest you could insert a javascript web resource into Case form and do conversion of "br to real new line" when the form on load, this process is rapid,

and I thought it would require less job than custom workflow.

function formatDescription(executionContext) { var formContext = executionContext.getFormContext(); var val = formContext.getAttribute("description").getValue(); var newVal = val.replace(//gi, "\n"); formContext.getAttribute("description").setValue(newVal); }

Email content:

Case description after executed js function:

Regards,

Clofly

Was this reply helpful? Yes No
jmillsjmills 31 on at

Like (0)

Report

Hello! This looks fantastic, and quite a bit simpler. Thank you! I have added the resource to the resource library and set it to run "OnLoad" but I am currently getting a script error. The code runs fine in an online Javascript validator, but unfortunately I get "ReferenceError: ConvertLineBreaks is not defined at eval (eval at RunHandlerInternal). Any further thoughts there at all pretty please? What could I be missing?

Was this reply helpful? Yes No
cloflyMao 25,210 on at

Like (0)

Report

Hi jmill,

Could you share me your form properties settings?

Below is mine:

Have you checked the option below for formatting function?

What's more, it would be better if you could share your original description with br tag in Case form.

Also, please try to use T.I.A's anwser to test again:

var newVal = val.replace(" ", "\n"); if your br tag is instead of 

Regards,

Clofly

Was this reply helpful? Yes No
jmillsjmills 31 on at

Like (0)

Report

Hello! Thank you so much for your swift reply. Much appreciated!

Yes - so this is the script error... (and you can see the original description in the background).

This is my form libraries:

I didn't have this tickbox checked, but then I did tick it and it still produces the same script error (having published all customisations).

And this is what i have in the web resource content:

Thanks very much! I'm very appreciative of your help.

Was this reply helpful? Yes No
Verified answer

cloflyMao 25,210 on at

Like (0)

Report

Hi Jmill,

Yes, please tick the tickbox.

From your error and screenshot, there is no function called ConvertLineBreaks.

You're calling a function called ConvertLineBreaks

However, my function name is formatDescription.

So you should change it to ConvertLineBreaks, that's your own function name.

Regards,

Clofly

Was this reply helpful? Yes No
jmillsjmills 31 on at

Like (0)

Report

Clofly that is absolutely fantastic! Thank you so much. I really appreciate you walking me through that so simply, and I have managed to get the result I was after.

Thank you so much again! You're a true legend of the Dynamics world in my view now!

Regards,

Jon

Was this reply helpful? Yes No
jmillsjmills 31 on at

Like (0)

Report

Hello Clofly! Hoping you're still around. Is there anything I can add to your JS so that it won't run if the field it's looking for is blank?

Was this reply helpful? Yes No