Best way to transform Oracle standard reports

[craig811]

Hi,

I would like to re-format some of the standard Oracle report output into a more readable format. I can then also use them in my Power BI model.

However, when I try and split the data using Power Query it does not offer a fixed width option like Excel.

What would the best option? I have used 'Space' delimiter, however it then splits data across more then one column.

Thank you in adavnce 

[Fowmy · Accepted solution]

@craig811 

Use the following option in Power Query

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn