Forum Discussion

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

DATE FROM A 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
idage's avatar
idage
Icon for Helper I rankHelper I
3 years ago

Thank you very much for your help .

It generally works but it give me Error when it find cells containin NULL or date in this format:

 

03/11/2023

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

 

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

     

    • Vijay_A_Verma's avatar
      Vijay_A_Verma
      Icon for Most Valuable Professional rankMost Valuable Professional
      3 years ago

      Use this in a custom column

      try [a=Text.From([Dates]), b=Text.Start(a, 6) & Splitter.SplitTextByCharacterTransition({"0".."9"}, (c) => not List.Contains({"0".."9"}, c)) (Text.Middle(a, 6, Text.Length(a))){0}][b] otherwise null