Forum Discussion

idage's avatar
idage
Icon for Helper I rankHelper I
3 years ago
Solved

DATE FROM TEXT STRING

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.

 

Need Help
  • Royel's avatar
    Royel
    3 years ago

    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.

1 Reply

  • Royel's avatar
    Royel
    Icon for Super User rankSuper User
    3 years ago

    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.