Hello all!
I am trying to convert a TXT file into Excel file. The problem is, this file contains some data that are in different lines and sometimes we can have 100 lines, sometimes 50 lines.... and so goes on.
If there is a way to convert all information of this TXT file into the excel that would make an outstanding change in my line of work, by removing copy and paste.
Thanks in advance!
@Joker_Hazard
The point here is do we need to format the lines?
or you just want the text to be output as the same format of text input, without any delimiters?
Hi @Joker_Hazard
Can you provide some sample input and expected output It will help us get a better understanding of the usecase.
We will be happy to help : )
Hello Qiu. Thank you very much for the attention.
Your solution does attend my requirement, however I would to have a few modifications, I don't know if alteryx can do that, but sill....
The output on the the excel should respect the blank spaces that the notepad has. I am pretty sure that the input tool is not able to "respect" those spaces, so it would require some data treatment afterwards, am I correct?
Is it possible? Thank you very much
Hello atcodedog05, good to see you again!
I gave a brief explanation for Qiu about the desired output, kindly check that out, I think it would answer your question.
Thanks in advance for the help, have a great sunday!!
Cheers
Hi @Joker_Hazard ,
Could you please check the below link.
Similar requirement achieved with python tool and Xlsxwriter package.
Re: create a report - Page 2 - Alteryx Community
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |