Extract number values from column

Vvelarde

That was it! You know, I saw that blog article and it looked more complicated than what I thought I needed, but after you pointed me in that direction, I took my time with it, and it worked!

FYI: For others who have the same request, here's what my query looks like:

let
CharsToRemove = List.Transform({32,46,33..45,47,58..126}, each
Character.FromNumber(_)),
    Source = Folder.Files("F:\Data\Testdata"),
    #"Combined Binaries" = Binary.Combine(Source[Content]),
    #"Imported CSV" = Csv.Document(#"Combined Binaries",[Delimiter=",", Columns=40, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Added Custom" = Table.AddColumn(#"Imported CSV", "Cost", each Text.Remove([Mycolumnname],CharsToRemove))
in
    #"Added Custom"