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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have an error : 

"Expression.Error : Désolé... Nous n'avons pas pu convertir une valeur de type Record en type Text.
Détails :
Value=
Type fichier=SuiviHebdo16275_Excedent_20230702
Type=[Type]"

 

"Type fichier" is the name of my column.

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Anonymous 

    Your Column datatype should be Text

    Find the pbix file and implement same. Working as per sample data you shared
    https://drive.google.com/file/d/1EFQfZpI_s4Z2xzz2-c57l2dG6mNktkST/view?usp=sharing

     


    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