Skip to content

influence160/marovea-etl

Repository files navigation

marovea-etl

ETL Tool for manual graphical transforming text file

Is a descktop application developed in Elipse RCP

the goal of this project is to apply a transformation to a long structured text where a manual processing would take alot of time and thus save time.

the application must display the text in a table then allow us to apply the same transformations on all the elements of a column

but before to display text in a table we must define how (columns separators or length of columns)

Exemple

take for example a text with this structure

    1242	Dossiers ressources humaines	RH	3YUIY9	Consomateur	
    893	Dossier administratif	ADM	RIO94	Lecteur		
    8830	Dossier social	USR	JO938	Contributer	 
    983	Projets	USR	HHR89	Contributer	
    5563	Projets informatiques	USR	89RJRJ	Contributer
    ...

we want to transform it to have a text like this

    Dossiers ressources humaines - 1242 - 3YUIY9 
    Dossier administratif - 893 - RIO94
    Dossier social - 8830 - JO938
    Projets	- 983 - HHR89
    Projets informatiques - 5563 - 89RJRJ
    ...

The user begins by giving the path of the text file and the unique separator which is the character tab (\t).
The application displays the text in a table containing columns of text separated by the column separator (\t).
We have then the following columns C1, S1, C2 S2, C3, S3, C4, S4, C5 (all cells in the columns S1, S2, S3 and S4 contains the character tab).
The user delete the columns C3, C5, S3 and S4.
The user modifie the content of the columns S1 and S2 and give the value " - " to this columns.
The user move the column C2 to the first position, S1 to the 2nd position, C1 to the 3rd, S2 to the 4rd.
The user save the table content to a file.

About

ETL Tool for manual graphical transforming text file

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages