web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps String manipulation on...

Power Apps

Answered

String manipulation on both start and end

(0) Share

Report

Report

Posted on by SmoothOperator

48

Hello,

I have a variable called varBase which has a looooong string value inside.

I want to "trim it" and especially delete some characters on both start and end of this value.

I have managed to remove the first 22 characters that I want out, by using :
Right(varBase, Len(varBase) -22)

However, simultaneously i want to remove the double quote character " [Ascii 34 / Char(34)] at the end.
Any ideas anyone?

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @SmoothOperator Mid(Right(varBase, Len(varBase) -22),1,len(Right(varBase, Len(varBase) -22))-1)
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@SmoothOperator

Substitute(Right(varBase, Len(varBase) -22),""","")

if there was only one " in the string. If there are more and you want to replace the last one

With( {no:CountRows(MatchAll(varBase, """)), Substitute(Right(varBase, Len(varBase) -22),""","",no)
SmoothOperator 48 on at

Like
a
(0)

Report
Copy link

Link copied!

really appreciate your quick responses!!! @Drrickryp @rubin_boer

Join the conversation