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?
Solved! Go to Solution.
hi @SmoothOperator Mid(Right(varBase, Len(varBase) -22),1,len(Right(varBase, Len(varBase) -22))-1)
hi @SmoothOperator Mid(Right(varBase, Len(varBase) -22),1,len(Right(varBase, Len(varBase) -22))-1)
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)
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
204 | |
70 | |
49 | |
48 | |
20 |
User | Count |
---|---|
252 | |
125 | |
84 | |
75 | |
74 |