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...
GabsMello If the Power Query solution provided by rsbin works - that's great and preferred to DAX. I haven't downloaded the file but it should be possible, my Power Query just isn't as strong as my DAX.
If not, DAX also has some text functions you can use to search for the underscore _ and then keep the characters to the left and right of these. Then you can check if they're numeric or not.