DATE FROM TEXT STRING

[idage]

Goodmorning community,

i need to solve a problem. I have a column containing for ex:

03-Jul-23 A

08-Nov-23*

03/11/2023

03/11/2023 A

03-Jul-23

and i need to extract date all in the same format.

Could you help me?

Thank you very much in advance.

[Royel · Accepted solution]

Hi @idage , to do that load data and go to power query

Step 1: Extracted Text Before Delimiter

= Table.TransformColumns(#"Filtered Rows", {{"Date", each Text.BeforeDelimiter(_, " "), type text}})

Select Column -> Transform -> Extract -> Text Before Delimiter

Step 2: Replace Value (Replace * with space)

= Table.ReplaceValue(#"Extracted Text Before Delimiter","*","",Replacer.ReplaceText,{"Date"})

Select Column -> Transform -> Replace Values

Step 3: Change Data Type (Output) 

Regards
Royel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.