#include <CtrlLib/CtrlLib.h>

using namespace Upp;

Vector<String> SpliteLine(String& line)
{
	// example
	return Split(line, "\t", false);
}

GUI_APP_MAIN
{
	String s = LoadFile(TXT_file_path);
	StringStream ss(s);
	FileOut out(csv_file_path);
	while(!ss.IsEof() && !ss.IsError())
	{
		String line = ss.GetLine();
		Vector<String> fields = SpliteLine(line);
		if(!fields.GetCount()) continue;
		String r = CsvString(fields[0]);
		for(int i = 1; i < fields.GetCount(); i++)
			r << ";" << CsvString(fields[i]);
		
		r << "\n";
		
		out << r;
	}
}

Vector<String> SpliteLine(String& line)
{
       ASSERT(line.GetCount() >= 23);
	Vector<String> r;

        r.Add() = line.Mid(0, 3);
        r.Add() = line.Mid(3, 8);
        r.Add() = line.Mid(11, 8);
        r.Add() = line.Mid(19, 4);

	return r;
}

PriceListGenerator::PriceListGenerator()
{
	CtrlLayout(*this, "PriceList Generator");
	
	//menù-tool-status
	AddFrame(menu);
	AddFrame(tool);
	AddFrame(status);
	menu.WhenHelp = status;
	tool.WhenHelp = status;
	menu.Set(THISBACK(MainMenu));
	tool.Set(THISBACK(SubBar));
	
	//Progress
	status.Add(pi.RightPos(5, 200).TopPos(2, 15));   //Indicator inside my statusBar
	pi.Percent();
	pi.Hide();

	//String s = LoadFile(TXT_file_path);
	generate <<= THISBACK(LoadPriceList);
	//LoadPriceList(s);
}

void PriceListGenerator::LoadPriceList()
{
	String s = LoadFile("C:\\Users\\Matteo\\Desktop\\prova.txt");
	StringStream ss(s);
	
	int x = 0;
	pi.Show();
	//pi.Set(x,1000); //how can I get the right number of rows?
	
	FileOut out("C:\\Users\\Matteo\\Desktop\\output.csv");
	out << AddHeader();
	
	while(!ss.IsEof() && !ss.IsError())
	{
		String line = ss.GetLine();
		Vector<String> fields = SpliteLine(line);
                pi.Set(x++);                       // ProgressIndicator
		
		if(!fields.GetCount()) continue;
		
		String r = CsvString(fields[0]);
		for(int i = 1; i < fields.GetCount(); i++)
		{
			r << ";" << CsvString(fields[i]);
		}
		r << "\n";
		out << r;
	}
}

ProcessEvents();

 if (x % 200 == 0) pi.Set(x++);   

pi.Set(x, s.GetCount() / lineSize); 

"20200103";"0113E0            ";"SEMICUSCINETTO                ";"00000001594";"H ";Common part
"20200103";"0113E1            ";"SEMICUSCINETTO                ";"00000001582";"H ";Common part
"20200103";"0113E2            ";"SEMICUSCINETTO                ";"00000002264";"H ";Common part
"20200103";"0113E3            ";"SEMICUSCINETTO                ";"00000001667";"H ";Common part
"20200103";"0113E4            ";"SEMICUSCINETTO                ";"00000001667";"H ";Common part

"20200103";="0113E0            ";"SEMICUSCINETTO                ";"00000001594";"H ";Common part
"20200103";="0113E1            ";"SEMICUSCINETTO                ";"00000001582";"H ";Common part
"20200103";="0113E2            ";"SEMICUSCINETTO                ";"00000002264";"H ";Common part
"20200103";="0113E3            ";"SEMICUSCINETTO                ";"00000001667";"H ";Common part
"20200103";="0113E4            ";"SEMICUSCINETTO                ";"00000001667";"H ";Common part