Hello FME experts,
I have an Ascii file with a size of 75Mb. In this file there are several records with a fix recordlength of 256 characters.
There are no dividers such as ';' or ','.
Every record has its's own recordidentifier on the firtst 2 positions followed bij the city-code (4) like this: (00 is the begining of the ascii file and ends withe record 98, I have manipulated the data)
000413Albrondabeach 201604200000000000OBeaTax main branch 04 1020 20041300007572River Kopijnhoven 00034 8162PV 0000012210G00000000000000000000000000000020140101000N201601012016010119900EUR00 20041300000759River Denelk 00053 5461kB 0000000010G00000000000000000000000000000020140101000N201601012016010112303EUR00 20041300000248River Anfoony van Hobokenlns 00034 9161DR 0000000010G00000000000000000000000000000020140101000N201501012016010110574EUR00 20041300000703River Ty Breuk 00035 9171JH 0000000010G00000000000000000000000000000020140101000N201501012016010112272EUR00 20041301204086Boorkuhaal Pleedeern 00096 7191FN 0000044710G00000000000000000000000000000020140101000N201601012016010120616EUR00 20041301233026River Jadeflie 00016 2562lA 0000024010G00000000000000000000000000000020140101000N201601012016010115144EUR00
...
...
I received from a friend a solution for the programm GeoKettle.
Here the accii file is divided into portions of 256 characters with the help of FOLD.EXE with the following statement: ...GeoKettle\\coreutils-5.3.0-bin\\bin\\fold -w 256 (printscreen 1).
The result is put in a seperate textfile fold_Ascii.org.
This text file is later divided into several records depending on the recordidentifier and written into an Oracle database (printscreen 2).
How can I do the same in FME?
Thank you for your response.
Perry