Importing CSV with HTML markup in some values using PowerShell

Question

I have a CSV file where some of the values contain decoded HTML markups (e.g. <b%gt;Example</b%gt;) that I try to insert in a SharePoint list.

When I iterate through the values using PowerShell it splits up the strings at , no matter I do.
I have tried wrapping the strings with " and ' but then PowerShell throws this error:

update : Exception calling "Update" with "0" argument(s): "Invalid text value.

A text field contains invalid data. Please check the value and try again."

At C:\Scripts\Configuration\SystemConfiguration.ps1:41 char:22 + $spListItem.update <<<< () + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : DotNetMethodException

Here's an example on one of the values:

"<b>Dear {0} Team,</b><br/>{1} request was completed <a href='{2}'>{3}</a>.<br/><br/>{2}<br/><br/>To download the PDF of the form please click  <a href='{6}'>Here</a>.<br/>In case of questions, please contact {4}.<br/><br/>With best regards<br/><br/>{5}"

Can anyone provide me with some tips on how to ensure the above value can be successfully inserted?

Answer 1

I found my answer by fooling around with some HttpUtility methods.

$Value = <b>Dear {0} Team,</b><br/>{1} request was completed <a href='{2}'>{3}</a>.<br/><br/>{2}<br/><br/>To download the PDF of the form please click  <a href='{6}'>Here</a>.<br/>In case of questions, please contact {4}.<br/><br/>With best regards<br/><br/>{5}
[System.Web.HttpUtility]::HtmlDecode($Value)