Convert PDF report (header, body) to XLS ; separated
$30-250 USD
Ukończony
Opublikowano około 12 lat temu
$30-250 USD
Płatne przy odbiorze
The attached report in TXT format should be converted into a flat (Semicolon) separated file by executing a conversion EXE. Input is the file "input.txt" output is a new formatted file called "output.txt".
The file has a logical grouing that repeats itself:
Antal op. k .a l.d . . . . . . . . . . . . . 1
2001 SuperGros A/S Kærup Industrivej 12 Ringsted
Kategori Type
Fejlbeskrivelse / Løsningsbeskrivelse
Løbenr Indgået Dato Indgået Tid Produktnavn Afsluttet Dato Afsluttet tid Afsluttet af
T69086 11-01-12 13:53:51 Håndterm DT-800 CE-2204 12-01-12 10:40:50 644 Jens Larsen
T69088 11-01-12 14:53:51 Håndterm DT-800 CE-2204 12-01-12 10:40:50 644 Ole Petersen
Which should be formatted into the following string:
2001 SuperGros A/S Kærup Industrivej 12 Ringsted;T69086;11-01-12 13:53:51;Håndterm; DT-800 CE-2204;12-01-12 10:40:50; 644 Jens Larsen
2001 SuperGros A/S Kærup Industrivej 12 Ringsted;T69088;11-01-12 14:53:51;Håndterm; DT-800 CE-2204;12-01-12 10:40:50;644 Ole Petersen
Notes:
Search for the string "Antal op." to identify the header in the line below (aiming at copying it to the clippard) for subcequent inserting as a column in lines containing the body lines that come below.
The timestamp format varies: Some are format 13:53:51 others are format 08:53:51 i.e. search for the : to identify the ";" following the first time/date stamp. This appli for both time stamps in the lines.
There is no exact method of setting the ";" between (in the example above) the "Håndterm" and the "DT-800....". I.e. search for the first space following the first date/timestamp.
Requirement is both the exe and the perl code.
I will write a Perl script to reformat your text file to a semicolon delimited text file according to your specifications. I will provide the script and a compiled executable from the script. I have 20 years experience using Perl for data conversion and reformatting.