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

     

Omid_Motamedise's avatar
Omid_Motamedise
Super User
1 year ago

Hi ABC11 

 

Check this solution

 

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 [ource.Name = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each List.RemoveNulls(List.Transform(Text.Split([ource.Name]," "), (x)=> try Date.From(Text.Replace(x,"AM-","")) otherwise null)){0})
in
    #"Added Custom"
ABC11's avatar
ABC11
Resolver I
1 year ago

Hello Omid_Motamedise,

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

Please

Thanks