Special Characters

[MariaSerrano]

Hi,  We find ourselves trying to solve the following issue. We have a collection with words containing special characters such as á or ñ. We get the data from a txt file using a Schema.ini and we have no problem to get the data right there.  When we execute our process and we want to create a final txt. or an Excel file with the collection data, the special characters are changed to other characters. For exameple "María and Pequeño" is changed to "MarÃa and Pequeño". How can we solve this?  And , Is there any way to obtain a CSV file from a collection separated for example with pipes or other characters  like ~? Thanks, Maria Serrano

[NickZejdlik]

Are the characters showing up correctly within Blue Prism - are they only changing after writing the text to a file? If so, it is probably the encoding of the file causing the issue. You may need a code stage to output the string with encoding. Check out the WriteAllText method on MSDN, specifically the Encoding parameter. Hope that helps with the text file.