Select a tab character (select and copy the space between two column headers) Open the "Find and Replace" window (Press Ctrl + H) and replace all tab characters with comma. 8. Click Save As 9. Name the file, and change the Encoding: to UTF-8
Full Answer
What is the difference between ASCII and UTF-8 in Salesforce?
If the file has the format UTF-8 is has 13 characters but when the format is ASCII the number of characters is 12. The endpoint where the file is being sent only accepts the ASCII-encoded version, and fails on the UTF-8 encoded string salesforce normally produces. Show activity on this post. UTF-8 is a superset of ASCII.
How do I convert a URL string to hexadecimal in Salesforce?
Use the methods in the EncodingUtil class to encode and decode URL strings, and convert strings to hexadecimal format. You cannot use the EncodingUtil methods to move documents with non-ASCII characters to Salesforce.
How to convert a non-UTF-8 blob to UTF-8?
@DebadyutiSil String blobToString (Blob input, String inCharset) is a great solution to convert a non-UTF-8 Blob to UTF-8. Thanks! @DebadyutiSil, in static String blobToString (...), why do you assert hex's length is even?
Is UTF-8 a superset of ASCII?
UTF-8 is a superset of ASCII. The character codes 0-127 (i.e. the ASCII characters) are directly mapped to the binary values 0-127 so if your UTF-8 string only consists of ASCII characters it is already in ASCII format.
Encode CSV files
1. In Microsoft Excel, open the *.xlsx file 2. Select Menu | Save As 3. Enter any name for your file 4. Under "Save as type," select Unicode Text 5. Click Save 6. Open your saved file in Microsoft Notepad 7. Replace all tab characters with commas (",")
Select proper encoding when using the Import Wizard or Apex Data Loader
If you're using the Import Wizard, make sure that you choose right encoding option "Unicode (UTF-8)" on the "Upload the file" step.
What is the %xy method?
This method uses the supplied encoding scheme to determine which characters are represented by any consecutive sequence of the form "%xy". For more information about the format, see The form-urlencoded Media Type in Hypertext Markup Language - 2.0.
Can you use EncodingUtil to move documents to Salesforce?
You cannot use the EncodingUtil methods to move documents with non-ASCII characters to Salesforce. You can, however, download a document from Salesforce. To do so, query the ID of the document using the API query call, then request it by ID.