Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Created By: Alex Powers
- Website: http://www.itsnotaboutthecell.com
- LinkedIn: https://www.linkedin.com/in/alexmpowers/
- Contact: alexmpowers@itsnotaboutthecell.com
- */
- let
- Source = Web.Page(Web.Contents("https://www.bangkokairportonline.com/flight-status-departures/?fbclid=IwAR1_9FMoBsSaHPLitEdi0rwCSsBGqt0lGFMiPcw3RpXc0IM6NuKi_hoENsA")){0}[Data],
- #"Extract Number From Status" = Table.AddColumn(Source, "Status_b", each try Number.From(Text.Remove([Status], {" ", "-", "A".."z"})) otherwise null, type number),
- #"Split Column: ( and )" = Table.SplitColumn(#"Extract Number From Status", "To", Splitter.SplitTextByEachDelimiter({"(",")"}, QuoteStyle.Csv, false), {"City", "City Code"}),
- #"Changed Type" = Table.TransformColumnTypes(#"Split Column: ( and )",{{"Scheduled", type time}, {"Revised", type time}, {"Flight", type text}, {"Status", type text}})
- in
- #"Changed Type"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement