How to create CSV file with input txt file (without separator ) ?
Ho everybody ,
Someone can help me please ,
I have a text file with many rows ( one row = one row of a table ) I want to create a csv file
My problem is :
There is not separator column in the txt file , I know only the number of character of each columns.
For example :
My Table :
Table toto ( name char(10) , age int(2) , town char(10) )
Txt File : Loic 24Paris
Paulo 11London
Anthony 10Lyon
Wanted Csv File : Loic ;24;Paris
Paulo ;11;London
Anthony ;10;Lyon