Insertar datos separado por comas de un archivo a otro en una posición determinada comparando la fec
Publicado por Albino García Soto (6 intervenciones) el 08/01/2019 01:57:56
Buen día.
Tengo dos archivos con datos separados por comas y necesito añadir datos de uno de los archivos al otro comparando la fecha y el campo que corresponde a los datos del día, añadiendo los datos en una posición determinada, explico.
archivo1.txt
2019/01/06,21:00:00,1.0,996.0,4.0,427.5
2019/01/06,22:00:00,1.0,996.0,4.0,427.5
2019/01/06,23:00:00,1.0,996.0,4.0,427.5
2019/01/07,00:00:00,1.0,996.0,4.0,427.5
archivo2.txt
"06-01-2019 23:15:00","8.7","54","-0.0","7.8","358.7","6.3","0.4","0.0","0","*","*","*","*"
"06-01-2019 23:30:00","7.2","64","0.8","3.7","34.1","4.1","0.4","0.0","0","*","*","*","*"
"06-01-2019 23:45:00","6.1","69","0.8","2.3","57.2","3.8","0.4","0.0","0","*","*","*","*"
"07-01-2019 00:00:00","5.5","71","0.7","0.1","313.3","1.4","0.5","0.0","0","7.4","62","0.7","*","*","*","*"
archivo2.txt resultado final
"06-01-2019 23:15:00","8.7","54","-0.0","7.8","358.7","6.3","0.4","0.0","0","*","*","*","*"
"06-01-2019 23:30:00","7.2","64","0.8","3.7","34.1","4.1","0.4","0.0","0","*","*","*","*"
"06-01-2019 23:45:00","6.1","69","0.8","2.3","57.2","3.8","0.4","0.0","0","*","*","*","*"
"07-01-2019 00:00:00","5.5","71","0.7","0.1","313.3","1.4","0.5","0.0","0","7.4","62","0.7","1.0","0.4","427.5","996.0"
Agradezco de antemano el apoyo.
Tengo dos archivos con datos separados por comas y necesito añadir datos de uno de los archivos al otro comparando la fecha y el campo que corresponde a los datos del día, añadiendo los datos en una posición determinada, explico.
archivo1.txt
2019/01/06,21:00:00,1.0,996.0,4.0,427.5
2019/01/06,22:00:00,1.0,996.0,4.0,427.5
2019/01/06,23:00:00,1.0,996.0,4.0,427.5
2019/01/07,00:00:00,1.0,996.0,4.0,427.5
archivo2.txt
"06-01-2019 23:15:00","8.7","54","-0.0","7.8","358.7","6.3","0.4","0.0","0","*","*","*","*"
"06-01-2019 23:30:00","7.2","64","0.8","3.7","34.1","4.1","0.4","0.0","0","*","*","*","*"
"06-01-2019 23:45:00","6.1","69","0.8","2.3","57.2","3.8","0.4","0.0","0","*","*","*","*"
"07-01-2019 00:00:00","5.5","71","0.7","0.1","313.3","1.4","0.5","0.0","0","7.4","62","0.7","*","*","*","*"
archivo2.txt resultado final
"06-01-2019 23:15:00","8.7","54","-0.0","7.8","358.7","6.3","0.4","0.0","0","*","*","*","*"
"06-01-2019 23:30:00","7.2","64","0.8","3.7","34.1","4.1","0.4","0.0","0","*","*","*","*"
"06-01-2019 23:45:00","6.1","69","0.8","2.3","57.2","3.8","0.4","0.0","0","*","*","*","*"
"07-01-2019 00:00:00","5.5","71","0.7","0.1","313.3","1.4","0.5","0.0","0","7.4","62","0.7","1.0","0.4","427.5","996.0"
Agradezco de antemano el apoyo.
Valora esta pregunta


0