Forum Discussion

Chrisjr's avatar
Chrisjr
Icon for Helper IV rankHelper IV
2 years ago
Solved

Remove first characters of a column with condition

Hello All,    I have the following column:   Brand Volvo 2023 07 Volvo 2023 10 VW 2022 12 Peugeot BMW 2023 01 BMW Peugeot Audi     If the text of the column start...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    Hello, Chrisjr 

    let
    Source = your_table,
    nums = List.Buffer({"0".."9", " "}),
    tx = Table.TransformColumns(Source, {"Brand", each Text.TrimStart(_, nums)})
in
    tx
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
2 years ago

Hello, Chrisjr 

let
    Source = your_table,
    nums = List.Buffer({"0".."9", " "}),
    tx = Table.TransformColumns(Source, {"Brand", each Text.TrimStart(_, nums)})
in
    tx