Unanswered

How to trim the last character in string

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

How can I trim the last character from a string where I am concatenating the email address with ; as delimiter? I do not need the last semi-colon.

Any help is much appreciated.

Categories:

General topics

All responses (6)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

There is a similar thread that you can follow: https://powerusers.microsoft.com/t5/General-Power-Automate/Removing-the-last-character-in-the-string/m-p/141940

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

replace(variables('mailboxAddress'),';','')
Lenfant 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Neha56,

Did you manage to resolve this? I'm trying to do something very similar and the link suggested does not seem to work.
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,
did you try to use
replace(variables('mailboxAddress'),';','')
Lenfant 8 on at

Like
a
(0)

Report
Copy link

Link copied!

This solution will replace all instances of ';' which is not quite what I wanted. I finally opted for the solution in https://powerusers.microsoft.com/t5/General-Power-Automate/Removing-the-last-character-in-the-string...

This worked, albeit a small typo by me which is why it didn't work first time.
Jaco_Campher 99 on at

Like
a
(1)

Report
Copy link

Link copied!

For anyone else looking, this will only remove the trailing ; if it is there.

if(equals(last(triggerBody()['email']), ';'), substring(triggerBody()['email'], 0, add(length(triggerBody()['email']), -1)), triggerBody()['email'])

Replace the text in blue with your input.