Forum Discussion

ABC11's avatar
ABC11
Resolver I
1 year ago
Solved

Extract Date from Text in Column

Hello, In power Query- I would like to extract date from Source.Name column  in Lasest date column. Please help me here   Source.Name Lastest Date HZN All Last 7 - AM - 10-27-2024 05_31 AM...
Need Help
  • ABC11's avatar
    ABC11
    1 year ago

    Hello Omid_Motamedise,

    It working but when I click Table. All other column disappear. what would be the solution?

    Please

    Thanks

     

ThxAlot's avatar
ThxAlot
Super User
1 year ago

Easy enough,

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("lcoxDoAgDEDRqzTMNmkLCIxuDuoBJMS4s+n9I/EAVpY//LyczbxvMNUKy3ndEABhWluYUAIKiQPyh+V2TRm+dOzSqUdb6tL8T78KmZFFJ1YnTideJ6NOgk6iTpIp5QE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Source.Name = _t]),
    #"Extracted Date" = Table.AddColumn(Source, "Date", each Date.From(Text.BetweenDelimiters([Source.Name],"-"," ",1,1)))
in
    #"Extracted Date"