Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Junk characters displayed for currecny field when CSV file generated using SDK is opened in excel RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,

    We have generated a CSV & TXT file from CRM using SDK. 

    The issue is with Currency field. 
    string dynString = "test user,$15,452.00,india";
    This is displayed correctly in CSV or TXT files opened in notepad. However when we open this file in excel then we get junk characters "test user,$?15,452.00,india"

    We have tried this with UTF8,UTF16,UTF32,UniCode,Windows-1252 but nothing worked.

    Any suggestions?

    Thanks & Regards, Sumeet Ballani Senior Consultant Off: 91 22 40622618 | Cell: 91 9004406970 | Skype: sumeet.ballani sballani@iotap.com | www.iotap.com http://in.linkedin.com/in/sumeetballani

    Monday, December 30, 2013 6:00 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    CSV files need to the data to be correctly formatted. All text field enclosed in double quotes and comma used a column separator. Trying writing data as

    "test user", "$15,452.00", "india".

    HTH

    Sam

     

    Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    • Proposed as answer by Sam - Inogic Monday, December 30, 2013 6:34 AM
    Monday, December 30, 2013 6:34 AM