web

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

News and Announcements icon

Power Platform CommunityForums Power Apps remove quotes from string

Power Apps

Answered

remove quotes from string

(0) Share

Report

Report

Posted on by Yazeed_Ablan

87

Hi all,

i have a string i need to remove the quotes as shown in the example below , the quotes also are the first and the last character of the string,

Example :"data colon;image/png;base64,iVBORw0KGgoAAAANSUhEUgAAD"

i need to remove those quotes in Powerapps or in sharepoint list (my data source) .

thanks in advance,

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (3)

Sort by

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Substitute( String, OldString, NewString [, InstanceNumber ] )

String - Required. The string to operate on.

OldString - Required. The string to replace.

NewString - Required. The replacement string. OldString and NewString can have different lengths.

InstanceNumber - Optional. Use this argument to specify which instance of OldString to replace if String contains more than one instance. If you don't specify this argument, all instances will be replaced.

Was this reply helpful? Yes No
Verified answer

Yazeed_Ablan 87 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @TheRobRush
i already tried the Substitute function
it wont work with quotes ("")

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

You can use special Char() function in place of writing ".

I believe for " you'd use Char(34) in your Substitute.

On my cell so limited ability to look up the char() chart

Was this reply helpful? Yes No
SaiedNazarian 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
You have to use quotations like this:
Substitute( SourceString, """", "" )

Was this reply helpful? Yes No

Join the conversation