Power Query - Import Fixed Width (Delimited) Files
ฝัง
- เผยแพร่เมื่อ 11 พ.ค. 2024
- Learn how to import an older (yet still used) delimited text file format. The not-so-obvious subtleties will cost you valuable time.
Test File Download Link:
www.bcti.com//wp-content/YT_D... - วิทยาศาสตร์และเทคโนโลยี
Very clear explanation - thank you!
You are welcome. Thanks for watching.
It is a fairly common case in the company. Thanks for the explanation.
You are very welcome.
Yep, my company still uses this fixed width dinosaurs file, with some weird characters that even Trim & Clean fns can't deal with..
Thank you for sharing your knowledge and experience. 😊
My condolences. 😄 Thanks for watching.
Yip, still deal with then with header info that has different fixed widths. No luxury of PQ guessing. Appreciate the notepad tip. Will try that rather then using excel formulas.
Thanks for taking the time to watch.