Forum Discussion
vanessafvg
Community Champion
Community ChampionPower Query Question on removing last character if a certain value is present
I have a column that has 1.02 20.1 etc in, but someone has inputted some of them like 1.02. and 52.01 I only want to remove a . if it is the last character, any idea on how to do that?
Maybe you can use trim to trim all trailing dots.
On the Transform tab, select your column and choose Format - Trim,
Then adjust the code and change
Text.Trim
to:
each Text.TrimEnd(_,".")
MarcelBeugCommunity Champion
Community ChampionMaybe you can use trim to trim all trailing dots.
On the Transform tab, select your column and choose Format - Trim,
Then adjust the code and change
Text.Trim
to:
each Text.TrimEnd(_,".")
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi vanessafvg,
Please try the Text.TrimEnd function as MarcelBeug posted. Please feel free to ask if you have any other issue.
Thanks,
Angelia