Forum Discussion
juan jimenez
Sep 12, 2023Iron Contributor
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...
- Sep 14, 2023
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.
juan jimenez
Sep 12, 2023Iron Contributor
SergeiBaklan
Sep 13, 2023MVP
Please find query in attached file. in Source step change file path on your one. Result is
- juan jimenezSep 14, 2023Iron ContributorDear Sergei
Thank you very much for your proposal. Unfortunately, it didn't work when I added more lines to the text.
Could you tell me what went wrong?
This is the txt link
https://1drv.ms/t/s!AlPgnUYDBAuukhKK6qg6BPr41SqM?e=VRz89g
Juan- SergeiBaklanSep 15, 2023MVP
juan jimenez It looks like works since post is accepted. Good luck!
- juan jimenezSep 17, 2023Iron ContributorHello Sergei,
I apologize for insisting on this matter. I've tried importing these sentences, and I noticed that
1) not all the complete texts of the conversations appear, and
2) the order in which they were written has changed.
Could you please take a look at the attached PQ (https://1drv.ms/x/s!AlPgnUYDBAuukh9cF_02HLdlxqmr?e=fgrGGC)
and the txt in this link (https://1drv.ms/t/s!AlPgnUYDBAuukh7twVQBAt4qXE8L?e=KDCsjp)?
Thank you very much, Juan.
- SergeiBaklanSep 14, 2023MVP
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.