Forum Discussion

jj101's avatar
jj101
Frequent Visitor
3 years ago
Solved

Need to remove numbers from a column

I have a column that has a mix of numbers and text. Example:   Column ABC ABC2 123 456 A1B1   I need to remove the ones that have only numbers (123, 456) not the ones that have text and numb...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    3 years ago

    Use this in a custom column

    if Value.FromText([Column1]) is number then null else [Column1]
ThxAlot's avatar
ThxAlot
Super User
3 years ago
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcnRyVorVAdNGYIahkTGYNjE1g0gYOhkqxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column = _t]),
    #"Transformed Column" = Table.TransformColumns(Source, {"Column", each if (try Number.From(_))[HasError] then _ else null})
in
    #"Transformed Column"