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(_,".")
vanessafvgCommunity Champion
Community Championworks like a charm thanks MarcelBeug