Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to filter out only letter in a columns

i want to filter out  only words (numbers not allowed ) from a column without adding a column. Table.AddColumn(#"Changed Type", "Custom1", each Text.Select([Column1],{"A".."z"}))
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use this

    = Table.ReplaceValue(#"Changed Type",each [Column1],each if Value.Is(Number.From([Column1]), type number) then null else [Column1] ,Replacer.ReplaceValue,{"Column1"})
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks this worked is there a way that filter out like 

sample input  

sdjwd

122

33wdwq

213

adsdwd232

dw

output

sdjwd

33wdwq
adsdwd232
dw

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Use this

= Table.ReplaceValue(#"Changed Type",each [Column1],each if Value.Is(Number.From([Column1]), type number) then null else [Column1] ,Replacer.ReplaceValue,{"Column1"})