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 form...
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.

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.