1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Visual C++, Read file and Write on another file with modified Help

Discussion in 'C++' started by sh4sh4, Feb 21, 2012.

  1. sh4sh4

    sh4sh4 New Member

    Joined:
    Apr 30, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    0
    Hello Valuable Programmers,

    I have a little Problem with Read on a file and Write on another file with modified like;

    informations on a exel(.xls) sheet but it doesnt matter we should think like any file type like txt ...;

    For Example our xls or txt file have this informations initially;

    xxx 16 segment1
    xxx 1 segment2
    xxx 8 segment3
    yyy 70 segment4
    zzz 4 segment5
    kkk 2 segment6
    mmm 1 segment3
    mmm 1 segment7
    vvv 6 segment3
    ppp 1 segment1
    qqq 31 segment8
    qqq 50 segment2
    qqq 62 segment5

    i need to do change this informations like this;

    xxx total:25 segment1 16,segment2 1,segement3 8
    yyy total:70 segment4 70
    zzz total:4 segment5 4
    kkk total:2 segment6 2
    mmm total:2 segment3 1,segment7 1
    ...

    is anyone can make its on C++ its a very important for me,
    Please help me
    Thank you so much
    ....
     
  2. dearvivekkumar

    dearvivekkumar New Member

    Joined:
    Feb 21, 2012
    Messages:
    29
    Likes Received:
    5
    Trophy Points:
    0
    Hi have compiled and used on window using Visual studio 2008.

    Code:
    
    /**
     * Includes
     */
    #include <iostream>
    #include <string>
    #include <fstream>
    #include <map>
    #include <vector>
    #include <set>
    
    using std::string;
    
    /*
     * Typedefs
     */
    typedef std::pair<int, string> intStrpair;
    typedef std::multimap<string, intStrpair> MultiMap;
    typedef std::map<string, intStrpair> strPiarMap;
    
    
    int main(int argc, char* argv[])
    {
        /**
         * Read the input file and load it's content into a buffer.
         */
        std::fstream dataFile;
        dataFile.open("dataFileIn.txt", std::ios::in | std::ios::binary);
        if(!dataFile)
            return -1;
    
        dataFile.seekg(0, std::ios::end);
        int  length = dataFile.tellg();
        dataFile.seekg(0, std::ios::beg);
        char *const fileContent  = new char[length];
        dataFile.read(fileContent, length);
        dataFile.close();
    
        /**
         * Get a single line and put that into a multimap  container.
         */
        bool lastCharIsWhitespace = false;
        bool lastCharIsCR = false;
        int curIndex = 0;
        string word("");
        string key("");
        string value1("");
        string value2("");
        strPiarMap file;
    
        for(int i = 0; i < length; i++)
        {
            if(isspace(fileContent[i]))
            {
                if(lastCharIsWhitespace == true)
                {
                    continue;
                }
    
                if(curIndex == 0)
                {
                    key.assign(word);
                    curIndex ++;
                }
                else if(curIndex == 1)
                {
                    value1.assign(word);
                    curIndex ++;
                }
                else if(curIndex == 2)
                {
                    value2.assign(word);
                    strPiarMap::iterator findIt;
                    value2 = value2.append(" ").append(value1);
    
                    findIt = file.find(key);
                    if(findIt != file.end())
                    {
                        findIt->second.second.append(",").append(value2);                    
                        findIt->second.first = findIt->second.first + atoi(value1.c_str());
                    }
                    else
                    {
                        intStrpair p(atoi(value1.c_str()), value2);
                        file.insert(std::pair<string, intStrpair>(key, p));
                    }
    
                    curIndex = 0;
                    key.clear();
                    value1.clear();
                    value2.clear();
                }
                word.clear();
                lastCharIsWhitespace = true;
            }
            else
            {
                word.append(1, fileContent[i]);
                lastCharIsWhitespace = false;
            }
        }
        delete [] fileContent;
    
        /**
         * Write back the processed data to file.
         */
        dataFile.open("dataFileOut.txt", std::ios::out);
        if(!dataFile)
            return -1;
    
        strPiarMap::iterator it;
        for(it= file.begin(); it != file.end(); it++)
        {
            string line("");
            line.append(it->first);
            line.append(" Total:");
            char buf[10] = {'\0'};
            _itoa_s(it->second.first, buf, 10);
            line.append(buf);
            line.append(" ");
            line.append(it->second.second);
            line.append("\n");
    
            dataFile.write(line.c_str(), line.length());
        }
        dataFile.close();
    
        return 0;
    }
    
     
  3. dearvivekkumar

    dearvivekkumar New Member

    Joined:
    Feb 21, 2012
    Messages:
    29
    Likes Received:
    5
    Trophy Points:
    0
    output


    kkk Total:2 segment6 2
    mmm Total:2 segment3 1,segment7 1
    ppp Total:1 segment1 1
    qqq Total:81 segment8 31,segment2 50
    vvv Total:6 segment3 6
    xxx Total:25 segment1 16,segment2 1,segment3 8
    yyy Total:70 segment4 70
    zzz Total:4 segment5 4
     
  4. sh4sh4

    sh4sh4 New Member

    Joined:
    Apr 30, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    0
    Thank you very much my friend
     
  5. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,012
    Likes Received:
    203
    Trophy Points:
    0
    Occupation:
    Senior Support Engineer
    Location:
    England
    >>we should think like any file type like txt

    At one level this is true. But there is a huge difference between text files and Excel spreadsheet files, namely the internal formatting of those files. When editing Excel files you need to be careful to preserve the correct formatting otherwise Excel may not be able to read the new file.
     
  6. sh4sh4

    sh4sh4 New Member

    Joined:
    Apr 30, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    0
    Hello dearvivekkumar
    You are real c++ expert,thank you.
    i have a little another question to you,
    my lot of texts are longer that expected i made them short but not enough.
    For example:
    xxx_ttttttt_hhhhhhhhh_(sentence)_yahaa(sentence)_ 16 segment1
    xxx_ttttttt_hhhhhhhhh_(sentence)_yahaa(sentence)_ 1 segment2
    xxx_ttttttt_hhhhhhhhh_(sentence)_yahaa(sentence)_ 8 segment3
    yyy_ttttttt_hhhhhhhhh_(colcol)_yahaa(sentence)_ 70 segment4
    zzz_ttttttt_hhhhhhhhh_(colcol) 4 segment5
    kkk_ttttttt_hhhhhhhhh_(colcol) 2 segment6
    mmm_ttttttt_hhhhhhhhh_(colcol) 1 segment3
    mmm_ttttttt_hhhhhhhhh_(colcol) 1 segment7
    vvv_ttttttt_hhhhhhhhh_(colcol)_qq 6 segment3
    ppp_ttttttt_hhhhhhhhh_(colcol)_pp 1 segment1
    qqq_ttttttt_hhhhhhhhh_(colcol)_pp 31 segment8
    qqq_ttttttt_hhhhhhhhh_(colcol)_pp 50 segment2
    qqq_ttttttt_hhhhhhhhh_(colcol)_pp 62 segment5

    some of lines are ok working fine but in example xxx and yyy lines are dont work because they are too long ,how can i fix or modife this problem?
     
  7. dearvivekkumar

    dearvivekkumar New Member

    Joined:
    Feb 21, 2012
    Messages:
    29
    Likes Received:
    5
    Trophy Points:
    0
    @sh4sh4

    Can you bother to write the whole content of your file?
     
  8. dearvivekkumar

    dearvivekkumar New Member

    Joined:
    Feb 21, 2012
    Messages:
    29
    Likes Received:
    5
    Trophy Points:
    0
    @sh4sh4

    There was an error in the program which fails only for the last line if the last line does not have the new line character.

    For fixing it I have to make some minor changes which I'll write shortly.
     
  9. dearvivekkumar

    dearvivekkumar New Member

    Joined:
    Feb 21, 2012
    Messages:
    29
    Likes Received:
    5
    Trophy Points:
    0
    Code:
    /**
    Hello Valuable Programmers,
    
    I have a little Problem with Read on a file and Write on another file with modified like;
    
    informations on a exel(.xls) sheet but it doesnt matter we should think like any file type like txt ...;
    
    For Example our xls or txt file have this informations initially;
    
    xxx 16 segment1
    xxx 1 segment2
    xxx 8 segment3
    yyy 70 segment4
    zzz 4 segment5
    kkk 2 segment6
    mmm 1 segment3
    mmm 1 segment7
    vvv 6 segment3
    ppp 1 segment1
    qqq 31 segment8
    qqq 50 segment2
    qqq 62 segment5
    
    i need to do change this informations like this;
    
    xxx total:25 segment1 16,segment2 1,segement3 8
    yyy total:70 segment4 70
    zzz total:4 segment5 4
    kkk total:2 segment6 2
    mmm total:2 segment3 1,segment7 1
    ...
    
    is anyone can make its on C++ its a very important for me,
    Please help me
    Thank you so much
    .... 
    
    **/
    
    
    /*
    Hello dearvivekkumar
    You are real c++ expert,thank you.
    i have a little another question to you,
    my lot of texts are longer that expected i made them short but not enough.
    For example:
    xxx_ttttttt_hhhhhhhhh_(sentence)_yahaa(sentence)_ 16 segment1
    xxx_ttttttt_hhhhhhhhh_(sentence)_yahaa(sentence)_ 1 segment2
    xxx_ttttttt_hhhhhhhhh_(sentence)_yahaa(sentence)_ 8 segment3
    yyy_ttttttt_hhhhhhhhh_(colcol)_yahaa(sentence)_ 70 segment4
    zzz_ttttttt_hhhhhhhhh_(colcol) 4 segment5
    kkk_ttttttt_hhhhhhhhh_(colcol) 2 segment6
    mmm_ttttttt_hhhhhhhhh_(colcol) 1 segment3
    mmm_ttttttt_hhhhhhhhh_(colcol) 1 segment7
    vvv_ttttttt_hhhhhhhhh_(colcol)_qq 6 segment3
    ppp_ttttttt_hhhhhhhhh_(colcol)_pp 1 segment1
    qqq_ttttttt_hhhhhhhhh_(colcol)_pp 31 segment8
    qqq_ttttttt_hhhhhhhhh_(colcol)_pp 50 segment2
    qqq_ttttttt_hhhhhhhhh_(colcol)_pp 62 segment5
    
    some of lines are ok working fine but in example xxx and yyy lines are dont work because they are too long ,how can i fix or modife this problem? 
    
    */
    
    /**
     * Includes
     */
    #include <iostream>
    #include <string>
    #include <fstream>
    #include <map>
    #include <vector>
    #include <set>
    
    using std::string;
    
    /*
     * Typedefs
     */
    typedef std::pair<int, string> intStrpair;
    typedef std::multimap<string, intStrpair> MultiMap;
    typedef std::map<string, intStrpair> strPiarMap;
    
    
    int main(int argc, char* argv[])
    {
    	/**
    	 * Read the input file and load it's content into a buffer.
    	 */
    	std::fstream dataFile;
    	dataFile.open("dataFileIn2.txt", std::ios::in | std::ios::binary);
    	if(!dataFile)
    		return -1;
    
    	dataFile.seekg(0, std::ios::end);
    	int  length = dataFile.tellg();
    	dataFile.seekg(0, std::ios::beg);
    	char *const fileContent  = new char[length];
    	dataFile.read(fileContent, length);
    	dataFile.close();
    
    	/**
    	 * Get a single line and put that into a multimap  container.
    	 */
    	bool lastCharIsWhitespace = false;
    	bool lastCharIsCR = false;
    	int curIndex = 0;
    	string word("");
    	string key("");
    	string value1("");
    	string value2("");
    	strPiarMap file;
    	if(length < 1)
    		return -1;
    
    	for(int i = 0; i <= length; i++)
    	{
    		if((i == length) || isspace(fileContent[i]))
    		{
    			if(lastCharIsWhitespace == true)
    			{
    				continue;
    			}
    
    			if(curIndex == 0)
    			{
    				key.assign(word);
    				curIndex ++;
    			}
    			else if(curIndex == 1)
    			{
    				value1.assign(word);
    				curIndex ++;
    			}
    			else if(curIndex == 2)
    			{
    				value2.assign(word);
    				strPiarMap::iterator findIt;
    				value2 = value2.append(" ").append(value1);
    
    				findIt = file.find(key);
    				if(findIt != file.end())
    				{
    					findIt->second.second.append(",").append(value2);					
    					findIt->second.first = findIt->second.first + atoi(value1.c_str());
    				}
    				else
    				{
    					intStrpair p(atoi(value1.c_str()), value2);
    					file.insert(std::pair<string, intStrpair>(key, p));
    				}
    
    				curIndex = 0;
    				key.clear();
    				value1.clear();
    				value2.clear();
    			}
    			word.clear();
    			lastCharIsWhitespace = true;
    		}
    		else
    		{
    			word.append(1, fileContent[i]);
    			lastCharIsWhitespace = false;
    		}
    	}
    
    	delete [] fileContent;
    
    	/**
    	 * Write back the processed data to file.
    	 */
    	dataFile.open("dataFileOut2.txt", std::ios::out);
    	if(!dataFile)
    		return -1;
    
    	strPiarMap::iterator it;
    	for(it= file.begin(); it != file.end(); it++)
    	{
    		string line("");
    		line.append(it->first);
    		line.append(" Total:");
    		char buf[10] = {'\0'};
    		_itoa_s(it->second.first, buf, 10);
    		line.append(buf);
    		line.append(" ");
    		line.append(it->second.second);
    		line.append("\n");
    
    		dataFile.write(line.c_str(), line.length());
    	}
    	dataFile.close();
    
    	return 0;
    }
    
     
  10. sh4sh4

    sh4sh4 New Member

    Joined:
    Apr 30, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    0
    @dearvivekkumar

    Thank you very much again,i solved my problem,the problem was one or two illegal characters like (-,%,&...) in 6000 lines,and turkish characters like (ö,Ö,ü,Ü,ğ,Ğ...),after i cleared these characters program is working excellent,thank you very much again you saved my life i get into debt to you,i want to help you to my friend.

    Erkin,
     

Share This Page