Forum Discussion
Pattern search
Dear friends, I have a data that contains a column: 0000_AA_00000 Where 0 can be any number (0 to 9) and A can be any letter (A to Z) But this can be anywhere in the row We can have text 0000_A...
Power Query has a number of different Text functions you can use to clean up and remove unwanted characters.
Based on the sample you provided, I have done up a sample pbix attached.
Hoping this solution will resolve the majority of your various cases. But if not, you can use the various options provided to "clean" the column to arrive at the desired Pattern.
Hope this at least gets you started and you can see the logic. Let me know if you have any questions.
Regards,