Forum Discussion
Solved
Power query with txt for messages
hi, I would like to import the messages from conversations that I receive in txt format via Power Query. I have uploaded the "txt" here as a "docx" because this platform does not accept txt files...
That didn't work since dates were converted using US locale. With UK locale it work, please see attached. You may change in Change Type with Locale step.
1) Could you please clarify what is desired result for such blocks (if source is recognized correctly)
Where marked texts shall be or they shall be removed?
2) If you use From Folder connections files are appended, nothing is removed.
hi Sergei,
1) The lines marked in red should go with the text from the immediately preceding line that starts with a date. They are part of the text of the message corresponding to that day and time.
Can this operation be done with Power Query? Can you help?
Thank you very much, juan
1) The lines marked in red should go with the text from the immediately preceding line that starts with a date. They are part of the text of the message corresponding to that day and time.
Can this operation be done with Power Query? Can you help?
Thank you very much, juan
Okay, but it's better to know how above texts are separated in csv. Is that crlf, or lf or what. If you can't share .txt here perhaps you could share the source on OneDrive or like and share the link make it available for everyone.
Please find query in attached file. in Source step change file path on your one. Result is