Forum Discussion
Import data from .out
Hi, In our business, we import Bloomberg data in form of .out files daily. In Excel, it was easy, using VBA file dialog. Since the headers are not separated by delimiters and only data have deli...
AmiraBedh
Super User
Super UserTry to import data as Text/CSV > Transform Data > Try to locate the row where the data starts and remove all the rows above it.
You can proceed with renaming the column headers as needed, and apply any necessary data transformations.
Specify the delimiter by selecting "Use Custom Delimiter" in the Text/CSV dialog box.
If you want to automate the data import process, you can create a Power Query function for that
By mistake I replied this to my own question. It should've been a reply to Message 2!
