Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Where to add a Text.RemoveRange function in M / Power Query

I understand the syntax of Text.RemoveRange but I am not sure how to add this into M / Power Query. Scenario: TableX has a column called "Departure", which is an ID that features a leading zero. I n...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    You don't want TransformRows, you want TransformColumns, something like this:

    #"Drop Lead Zero" =
Table.TransformColumns(
    #"Changed Type",
    {
        { "Departure", each Text.RemoveRange(_, 0, 1) }
    }
)

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

You don't want TransformRows, you want TransformColumns, something like this:

#"Drop Lead Zero" =
Table.TransformColumns(
    #"Changed Type",
    {
        { "Departure", each Text.RemoveRange(_, 0, 1) }
    }
)

 

Pete