Forum Discussion

heriberto_mb's avatar
heriberto_mb
Frequent Visitor
1 year ago
Solved

Extract data after html tag

I want to extract the system status from the following page:  https://www.akamaistatus.com/   I was able to pull the html data, now I just want to pull the line that says "All Systems Operational"...
Need Help
  • Ahmedx's avatar
    Ahmedx
    1 year ago

    pls try this

     

    let
    Source = Text.FromBinary(Web.Contents("https://www.akamaistatus.com/")),
    Text = Text.BetweenDelimiters( Source, "<span class=""status font-large"">", "<span class=""last-updated-stamp  font-small""></span>" ),
    ImportedText = List.RemoveMatchingItems( List.Transform(Lines.FromText(Text),(x)=> Text.Trim(x)),{""}){0}
in
    ImportedText

     

heriberto_mb's avatar
heriberto_mb
Frequent Visitor
1 year ago

Thank you Ahmedx ! That works perfectly...

 

Can you explain the following line and tell me where can I learn more about it?

ImportedText = List.RemoveMatchingItems( List.Transform(Lines.FromText(Text),(x)=> Text.Trim(x)),{""}){0}

 

Ahmedx's avatar
Ahmedx
Super User
1 year ago

 

  • Lines.FromText(Text): This function converts the variable Text into a list of lines. Each line from the text becomes an individual element in the list.

  • List.Transform(..., (x) => Text.Trim(x)): This applies a transformation to each line in the list created in step 1. The transformation involves trimming the whitespace from both the beginning and end of each line using Text.Trim(x).

  • List.RemoveMatchingItems(..., {""}): This removes any empty strings (i.e., "") from the list that resulted from the transformation in step 2. If any lines were just whitespace, they are removed at this point because they become empty after trimming.

  • {0}: This refers to the first element of the remaining list after empty strings are removed. It extracts the first non-empty line of the original text.