This software change the delimiter after the first column of csv tables. It can be used to reduce the number of columns for Merge tables SQLite. Tables are processed line by line in parallel.
julia main.jl ';' tab
┌────────────────────────────────────────────────┐
│ Replace first delimiter (c)Frederic PONT 2020 │
│ Free Software GNU General Public License │
└────────────────────────────────────────────────┘
Usage :
julia main.jl <inital delimiter> <final delimiter>
Examples :
julia main.julia : replace TAB by ; after the 1st column
julia main.jl tab ";" : replace TAB by ; after the 1st column
julia main.jl ";" tab : replace ; by TAB after the 1st column
args = [";", "tab"]
Initial delim = <;>
Final delim = < >
Start processing
processing case4.csv
processing case5.csv
processing case3.csv
processing case1.csv
processing case2.csv
All done in 0.07 sec !
Manual :
1- install Julia 1.3 free programming language
2- unzip the software
3- copy your n tables in csv in the “data” directory
4- execute the software by the command :
Usage :
julia main.jl <inital delimiter> <final delimiter>
Examples :
julia main.julia : replace TAB by ; after the 1st column
julia main.jl tab ";" : replace TAB by ; after the 1st column
julia main.jl ";" tab : replace ; by TAB after the 1st column
5- processed file is in the “result” directory.