I have a product catalog in csv format. The file contains 6000 rows and 94 columns. Column 16 (P) contains product description in html code. The html code contains characters incompatible with my import tool (tool which imports products from csv to my website). Can I use Replace Pioneer to convert html in column P to UTF8 code?

Input Sample:

<p>The Dogtra YS300 is a bark activated no-bark collar made for small to medium sized dogs. The sound recognition sensor uses a microprocessor to distinguish between the dog’s bark and the surrounding ambient noise. The YS300 is fully waterproof and comes with a 2-hour rapid charge battery and charger.<br></p><p><span style="font-weight: bold;">Package Contents:</span><br></p><ul><li>Bark Collar with collar strap</li> <li>Lithium Polymer Battery Charger</li><li>Owner's Manual</l

Sometimes if we use Excel to open csv file, we may get some invalid character like your examle. The reason may be: the csv file is UTF-8 encoded, but Excel could not correctly detect its encoding. The solution is convert UTF-8 file to UTF-8-BOM file, so that Excel can dectect it correctly.