Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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
Labels (3)
1 Reply
Anonymous
Not applicable