How to read a CSV file (google doc) line by line in c++

From your comment:
I am observing the garbage characters inside Visual Studio IDE while debugging. I am using VS6.0.

OK so I think it is a problem about character sets. As Andrew said it, your text file is probably not a Unicode text file and since your computer is not french you can't display the characters properly. (Visual Studio will take the current locale settings and load the corresponding characters set for the 8-bits characters).

I suggest that you convert your input string into unicode strings using these functions:

//just to set a max size for the string buffers
#define MAX_SIZE 1000
//change this value to use a different characters set
#define CODE_PAGE 1250

//converts an ansi string (8 bits per character)
//into a unicode string (16 bits per character)
//using the code page provided by constant CODE_PAGE
//Note: do not delete or free the returning pointer!
WCHAR* AnsiToUnicode(LPCSTR ansiString)
{
    static WCHAR unicodeString[MAX_SIZE];
    MultiByteToWideChar(
        CODE_PAGE,          // code page
        MB_PRECOMPOSED,     // character-type options
        ansiString,         // address of string to map
        -1,                 // number of bytes in string
        unicodeString,      // address of wide-character buffer
        MAX_SIZE            // size of buffer
    );
    return unicodeString;
}

//converts a unicode string (16 bits per character)
//into an ansi string (8 bits per character)
//using the code page provided by constant CODE_PAGE
//Note: do not delete or free the returning pointer!
char* UnicodeToAnsi(LPCWSTR unicodeString)
{
    static char ansiString[MAX_SIZE];
    WideCharToMultiByte(
        CODE_PAGE,      // code page
        0,              // performance and mapping flags
        unicodeString,  // address of wide-character string
        -1,             // number of characters in string
        ansiString,     // address of buffer for new string
        MAX_SIZE,       // size of buffer
        NULL,           // address of default for unmappable characters
        NULL            // address of flag set when default
    );
    return ansiString;
}

//test
void test()
{
     FILE *fp;
     char str[100];
     fp = _tfopen(_T("D:\\myfile.csv"), _T("rt"));
     while (fgets(str, 100, fp))
     {
          //convert the string
          WCHAR* wstr = AnsiToUnicode(str);
 
          //do something......
     }
}

Or you may use cleaner versions of these functions:

int AnsiToUnicode(LPCSTR ansiString, LPWSTR unicodeString, int maxSize)
{
    return MultiByteToWideChar(
        CODE_PAGE,          // code page
        MB_PRECOMPOSED,     // character-type options
        ansiString,         // address of string to map
        -1,                 // number of bytes in string
        unicodeString,      // address of wide-character buffer
        maxSize             // size of buffer
    );
}

int UnicodeToAnsi(LPCWSTR unicodeString, char* ansiString, int maxSize)
{
    return WideCharToMultiByte(
        CODE_PAGE,      // code page
        0,              // performance and mapping flags
        unicodeString,  // address of wide-character string
        -1,             // number of characters in string
        ansiString,     // address of buffer for new string
        maxSize,        // size of buffer
        NULL,           // address of default for unmappable characters
        NULL            // address of flag set when default
    );
}

And don't forget to enable unicode string display under Visual Studio:
To set your debugger options to display Unicode strings, click the Tools menu, click Options, click Debug, then check the Display Unicode Strings check box.

This function should work properly (well it does for me!).
You are maybe trying to read a "french" file from a non-french version of windows?

Try changing the locale before reading the file:

//required for the locale function
#include <locale.h>

void yourFunction()
{
    //changed locale settings for the current thread only to french
    setlocale(LC_ALL, "French");
    //then open and read your text file
    //...
}

i belive you should use UNICODE version of fgets()

fgets() will try to open and read file as ANSI. If you are using TCHARs, you should use _fgetts(). Otherwise, to read Unicode file, you should use fgetws(), and character buffer should use WCHAR, not char.

In the code you sent me, you use fopen with "r". If you want to read text, you should use "rt".