Forum Discussion

ExcelKnut's avatar
ExcelKnut
Frequent Visitor
1 year ago
Solved

Remove trailing commas

If values in a column contain a trailing comma, I need to remove it.  However, commas separating values within that column need to be kept.  I tried using Text.TrimEnd but that didn't work.     Any...
Need Help
  • dufoq3's avatar
    dufoq3
    1 year ago

    Hi ExcelKnut, what do you mean that Text.TrimEnd didn't work?

     

    Before

    After

    let
    Source = #table(null, {{"Native American,"}, {"Asian, Black,"}}),
    Custom1 = Table.TransformColumns(Source, {{"Column1", each Text.TrimEnd(_, ",")}})
in
    Custom1
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

ExcelKnut Add a new custom column with the following formula:

= Text.Replace(Text.TrimEnd([YourColumnName], ","), ",,", ",")

nathancwatkins's avatar
nathancwatkins
Icon for Helper II rankHelper II
1 year ago

Use Split by Delimiters, and start from the end.

 

--Nate