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.
Dear Sergei,
your PQ was working perfectly until a new txt came and a problem arised. Would you mind telling me problem and even correcting the attached coding?
https://1drv.ms/f/s!AlPgnUYDBAuukjaxyOz8oGFm60vd?e=jehfft
your PQ was working perfectly until a new txt came and a problem arised. Would you mind telling me problem and even correcting the attached coding?
https://1drv.ms/f/s!AlPgnUYDBAuukjaxyOz8oGFm60vd?e=jehfft