How to extract only numbers or letters or specified characters from text strings using Power Query

preview_player
Показать описание
This is an example of text consisting of random numbers, random letters upper and lower case, punctuation marks, symbols and Hebrew letters: ANSII code from 32 to 126, and from 224 to 250. All randomly generated and randomly placed.
We would like to extract only the numbers
Or we would like to extract only the upper case letters
Or we would like to extract only the symbols and punctuation marks
Or we would like to extract only the Hebrew letters
Or any combination of the above
Doing this with Excel formulas will be very difficult because of a total lack of consistency
Doing this using UDFs is a possibility for letters, numbers and Hebrew letters, but the symbols and punctuation marks will be a problem.
The easiest and fastest way is to do this is with Power Query using the Text.Select and Text.Remove formulas in added Custom Columns.
Рекомендации по теме