Reorder data from a text file to columns

Navigation
0

I need to reorder the data I have in a text file, everything is mixed, without separators and I do not have the knowledge to separate the data by types in different columns, one column for str and another one for float . The file is hugely large. How can I manage these types of problems?

  • The initial file is in PDF , its structure is more or less:
    •   

    Ecode | Id | Name | salary | birthdate | income

  • The problem is that later there are other isolated and disordered data vertically, among these: deducciones , deducciones SSO , impuestos and others ...

    • When the file was transferred to text with the PDF to TXT , the tabulation and the order of the files were lost, everything remains in a single column when I pass it to Excel (the file is also too big and heavy).

        
    asked by MRivas 17.05.2017 в 21:27
    source

    0 answers

    Why does hibernate create the id column when I specify another primary key? query inserts me a single value Mysql - PHP [closed]