Create a text converter
Employer
[no-member:pro]Oleg[/no-member:pro]Oleg
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentwithout prepayment
Payment methodsBank transfer, Electronic money
Acceptance of requestsclosed
Project description
A universal text converter is required
Who is in the subject, he knows that sqlite understands date in the format of GYGG-MM-DD h:mm:ss (one gap between the date and time)
Some application uploads data, but the date is converted to DD/MM/GHG h:mm:ss (text file) separator tabulation
Universality is that data can be output in the form
There may be other options. The format of the date remains unchanged.
Tables can be large, up to several hundred thousand lines.
I need this format on the way out, the dividers are tabulation. There is a gap between the date and time.
If the incoming file is different, only the date should change at the output. Don't touch the rest of the values.
Only specific columns are allowed to be downloaded, as well as In practice, only 2-3 columns are required.
I have attached a file that needs to be converted. Again, there may be a couple more shapes, roughly the same, but different columns. The date will be the same.
I know this is a simple task, so you can budget yourself.
It's just that you can do it all through excel, but you don't want to do so many body movements.
P.S.
Who will offer the service to derive from these data the necessary statistics, we will discuss the budget separately. I used sqlite to derive the statistics myself, the only problem was converting the date. But I would be more interested in the scheme not the application-converter-sqlitestudio, and the application-program for statistics.
The only condition is a short time, universality and correctness of statistical calculations.
I won't offend you for the beautiful decision.
Write it, I'll answer it right away.
Who is in the subject, he knows that sqlite understands date in the format of GYGG-MM-DD h:mm:ss (one gap between the date and time)
Some application uploads data, but the date is converted to DD/MM/GHG h:mm:ss (text file) separator tabulation
Universality is that data can be output in the form
There may be other options. The format of the date remains unchanged.
Tables can be large, up to several hundred thousand lines.
I need this format on the way out, the dividers are tabulation. There is a gap between the date and time.
If the incoming file is different, only the date should change at the output. Don't touch the rest of the values.
Only specific columns are allowed to be downloaded, as well as In practice, only 2-3 columns are required.
I have attached a file that needs to be converted. Again, there may be a couple more shapes, roughly the same, but different columns. The date will be the same.
I know this is a simple task, so you can budget yourself.
It's just that you can do it all through excel, but you don't want to do so many body movements.
P.S.
Who will offer the service to derive from these data the necessary statistics, we will discuss the budget separately. I used sqlite to derive the statistics myself, the only problem was converting the date. But I would be more interested in the scheme not the application-converter-sqlitestudio, and the application-program for statistics.
The only condition is a short time, universality and correctness of statistical calculations.
I won't offend you for the beautiful decision.
Write it, I'll answer it right away.
