Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dradair
New Member

retain multiple rows from filtered points

I am looking for a means to filter and retain all lines between two relative points in an imported unformtted, text file. The text file is ~300k lines, but the report I am seeking has a header that contains 'BEPS' and the following report starts with 'BEPU'. the rows between these two points are in a table, and are the rows I'd like to retain. Is there a means to have it determine this relative position and retain all lines between these points?

 

BEPS.PNG

2 REPLIES 2
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @dradair,

 

Could you post the texts here instead of the screenshot, so that we can do some tests easily and try to find a solution for you? It's better that you can just share the text file(with just some sample/mock data). You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. Smiley Happy

 

Regards

Sorry about that.

The data file is here:

https://www.dropbox.com/s/m7ejbaujcgt0y8c/PROJ%20DATA%20-%20Baseline%20Design.SIM?dl=0

Please lmk if the link doesnt work. the SIM file is just text; opens in Notepad++. 

 

The main goal would be to extract from the BEPS Report to the BEPU report (only b/c its the end of the BEPS report). Report length will vary, location in file will vary.

I have gotten the file to import as a text-query, and can filter down to certian specific lines which are labeled (ex: TOTAL SITE ENERGY line) and can break data labels / numbers appart successfully. The issue has been that the final 'MBTU' line (just below the line of  =====) is really what I'm after and does not have some type of line / data label on that line. Thats why I'm afte the BEPS report, and will filter / work from thre. If theres another way - i am all ears!

 

Yes, it is a total of the above MBTU lines above, this is really the only line I care about. If its easier to get the individual lines and sum them later - thats fine too. Ideally in this case, it would be possible to concatanate the EMCC ELECTRICITY (etc) line with the line below of MBTU and the numbers. That woudl be awesome too. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors