Power Query - replace all numbers with null

Question

So, I have a datalist of cities saved in Excel, which I want to visualize in PowerBI. However, some of the cities contain a zipcode. This zipcode only exists from numbers.

Is it possible to replace all numbers in that column with "" (nothing)? Or another option is to check if the value starts with a number and then removes the first 4 characters in that cell?

Any ideas on how this can be done?

Answer 1

• Trim the start of your columns ("Custom") entries using this command:

Table.TransformColumns(NameOfPreviousStep,{{"Custom", each Text.TrimStart(_,List.Transform({0..9}, each Number.ToText(_)))}})