Editor avanzado desde un origen de página web

[gpiero]

Hola

Estoy trabajando con datos de una tabla HTML en un sitio web.

¿Hay alguna manera de ocultar todo el código HTML generado desde el origen de datos de la página web?

Es muy aburrido desplazarse hacia abajo todas estas filas cada vez para editar en el Editor avanzado.

saludos

 #"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 - Tal vez intente separar ese paso en su propia función. A continuación, no se saturará la consulta principal.

[pranit828]

Hola @gpiero

No hay manera de ocultar todo el código HTML generado desde el origen de datos de la página web.

Sin embargo, copiaría el código M en el editor de Notepad++ y no usaría la palabra wrap, esto lo mostrará en una línea.

botón de ajuste de palabras en El Bloc de notas++

Una vez que mi edición está hecha, lo copiaría y pegaría de nuevo.

[gpiero]

Hola @pranit828 ,

muchas gracias por su consejo. Por el momento no creo que sea la mejor solución para mí. Trabajar de esta manera significa, si uderstood bien, copiar y pegar n veces entre el Bloc de notas ++ y El editor avanzado aumentando los errores y problemas.

Gracias de nuevo

saludos

[pranit828]

Hola @gpiero

En ese caso, No hay forma de ocultar todo el código HTML generado desde el origen de datos de la página web.

[Greg_Deckler · Accepted solution]

@gpiero - Tal vez intente separar ese paso en su propia función. A continuación, no se saturará la consulta principal.

[gpiero · Accepted solution]

@Greg_Deckler

es muy probable que se refería a la solución a continuación.

El primer quey TbItemOverview contiene solo la instrucción para importar datos desde la página Web

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}}),

A continuación, en la nueva consulta, debería volver a crear el comando adecuado para modelar los datos.

Gracias por la dirección correcta.

saludos

[Greg_Deckler]

@gpiero - Sí, lo tienes, lo siento por no ser más específico!

[gpiero]

@Greg_Deckler

¿Significa que podría crear una especie de subrutina o una consulta independiente solo para importar datos?

Y luego abrir un nuevo quey para modelar datos y así sucesivamente?

¿Hay algún ejemplo para "encender la lámpara en mi mente"?

Gracias de antemano

saludos

[gpiero]

@Greg_Deckler

Me refiero a la dimensión de mi problema!!!!!!

He truncado con Bloc de notas ++ menos de 20k characthers. Eran 36 mil!!!!

Dejar
Source - File.Contents("C:-Users-Giamp-OneDrive-TOL Data Cloud-Analysis 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]): nth-child(1):nth-last-child(1) 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-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):nth-child(3):-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):2):2):2):2):2):2):2):2):2):2):2):2):2):2):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 > TD :not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(nth-child(14) + TD:not([colspan]):not([rowspan]):nth-child(nth-child(14) 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(((3 [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) , TABLA > * > 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) :not([colspan]):not([rowspan]):nth-child(4):nth-last-child(7) + TD:not([colspan]):not([rowspan]):nth-child(-15):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([[[[nth-last-child(6) + TD[colspan-""2""]:not([[[[nth-last-child(6) + TD[colspan-""2""]:not([[[[[1-last-child(6) rowspan]):nth-child(2):nth-last-child(5) + TD[colspan-"""4""]:not([rowspan]):nth-child(3):nth-last-child(4)" , "Columna7", "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]):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):nth-last-child(1), TABLE > * > TR > TD:not([colspan]):):nth-last-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(nth-child(11) 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):2):2):2):2):2):2):2):2):2):2):2):2):2):2):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:13) 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(6):nth-last-child(9) + TD:not((([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + TD:not((([colspan]):not([rowspan]):nth-child(6):nth-last-child(9) + 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([colspanpan]):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 > * > 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-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 > TD :not([colspan]):not([rowspan]):nth-child(1):nth-last-child(14) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-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): ([rows]nth- :nth-last-child(3) + TD[colspan-""10""]:not([rowspan]):nth-child(4):nth-last-child(2), TABLE > * > TR >