Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PauSe
Frequent Visitor

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 need to remove that leading zero. So instead of "09999", "02345", etc.,  I want "9999", "2345", etc.. 

I thought it may be preceded by something like a Table.Transformrows in M e.g.,

#"Drop Lead Zero" = Table.TransformRows(#"Changed Type", Text.RemoveRange([Departure], 0, 1))

 

But this (and many other attempts) does not work. So I guess I am struggling with where to position the function in M.

 

Your advice is appreciated! 

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @PauSe ,

 

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

1 REPLY 1
BA_Pete
Super User
Super User

Hi @PauSe ,

 

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors