Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Remove the date from a text

Hello everyone, I have a column of 15,000 lines corresponding to folder names. Some folder names have a date embedded in the name and I'd like to remove it. This date is of type YYYYMMDD and witho...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    HI Anonymous 

    In the ticket, you shared the wrong sample data before.
    Please share more sample data to get an accurate answer

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago


Please create custom column in Power Query and use below code

 

= Text.Select([Column],{" ","_","a".."z","A".."Z"})

 

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin