Forum Discussion

lipster26's avatar
lipster26
Frequent Visitor
4 years ago
Solved

Parse year from text

Hello,   Looking for the best way to parse the year from cells with text. The years at the beginning of the text could be done with splitting into columns, but how about the cells where the year is...
Need Help
  • rohit_singh's avatar
    rohit_singh
    4 years ago

    Hi lipster26 

    Crude but effective one-liner

    = Table.AddColumn(#"Changed Type", "Year", each Number.From(Text.Range([Text],Text.PositionOf([Text], "20",Occurrence.First),4)))

     

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! ğŸ˜Š

rohit_singh's avatar
rohit_singh
Icon for Solution Sage rankSolution Sage
4 years ago

Hi lipster26 

Crude but effective one-liner

= Table.AddColumn(#"Changed Type", "Year", each Number.From(Text.Range([Text],Text.PositionOf([Text], "20",Occurrence.First),4)))

 

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! ğŸ˜Š

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Nice. This is one of those problems that can be done many ways but the more robust you need the calculation to be, the more complex the solution has to be. Sometimes quick and dirty is good enough.