Advanced Editor from a Web Page source

[gpiero]

Hi,

I am working with data from an HTML table on a website.

Is there a way to hide all the HTML code generated from Web Page datasource?

It is very boring scrolling down all this rows each time to edit in Advanced Editor.

Regards

 #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:

[Greg_Deckler · Accepted solution]

@gpiero - Perhaps try separating that step into it's own function. Then it won't clutter up your main query.

[pranit828]

Hi @gpiero 

There is no way to hide all the HTML code generated from Web Page datasource.

However, I would copy the M code in Notepad++ editor and not use the word wrap, this will display it in one line.

 word wrap button on Notepad++

Once my edit is done, I would copy and paste it back.

[gpiero]

Hi @pranit828 ,

many thanks for your advice. At  moment I do not think it is the best solution for me. Working in this way means, if I uderstood well, copy & paste n  times between Notepad ++ and Advanced Editor increasing mistakes and issues.

Thanks again

Regards

[Greg_Deckler · Accepted solution]

@gpiero - Perhaps try separating that step into it's own function. Then it won't clutter up your main query.

[gpiero · Accepted solution]

@Greg_Deckler 

it is very likely you meant the solution below.

The first quey TbItemOverview contains only the statement to import data from Web page

let
    Source = TbItemOverview,
    #"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}}),

Then in new query I should recreate the proper command to model data.

Thanks for the right direction.

Regards

[Greg_Deckler]

@gpiero - Yes, you got it, sorry for not being more specific!

[gpiero]

@Greg_Deckler

Does it mean I could create a sort of subroutine or a separate query only for import data?

And then open a new quey for modeling data and so on?

Is there some example just to "turn on the lamp in my mind"?

Thanks in advance

Regards 

[gpiero]

@Greg_Deckler 

I mean below the dimension of my issue!!!!!!

I truncated with Notepadd ++  less than 20k characthers. It was 36k!!!!

let
Source = File.Contents("C:\Users\giamp\OneDrive\TOL Data Cloud\Analisi Fattacci\StatementOverview.htm"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6)"}, {"Column2", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6)"}, {"Column3", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5)"}, {"Column4", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5)"}, {"Column5", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(6), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(4)"}, {"Column6", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(9), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(5), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(4)"}, {"Column7", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(8), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(4), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(4)"}, {"Column8", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""2""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(8):nth-last-child(7), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(5), TABLE > * > TR > TD[colspan=""12""]:not([rowspan]):nth-child(1):nth-last-child(2), TABLE > * > TR > TD[colspan=""10""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(6) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(8):nth-last-child(3), TABLE > * > TR > TD[colspan=""13""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(6) + TD[colspan=""2""]:not([rowspan]):nth-child(2):nth-last-child(5) + TD[colspan=""4""]:not([rowspan]):nth-child(3):nth-last-child(4)"}, {"Column9", "TABLE > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(5) + TD[colspan=""5""]:not([rowspan]):nth-child(2):nth-last-child(4) + TD[colspan=""2""]:not([rowspan]):nth-child(3):nth-last-child(3), TABLE > * > TR > TD[colspan=""14""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(13) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(12) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(11) + TD:not([colspan]):not([rowspan]):nth-child(5):nth-last-child(10) + TD:not([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + TD:not([colspan]):not([rowspan]):nth-child(7):nth-last-child(8) + TD:not([colspan]):not([rowspan]):nth-child(8):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(9):nth-last-child(6), TABLE > * > TR > TD[colspan=""9""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(5) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(3) + TD[colspan=""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR >