cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yazeed_Ablan
Helper II
Helper II

Remove semicolons in multiline text sharepoint list

HI All, 

i have a multiline text in sharepoint list i need to remove the first semicolon and the last, just as shown in the example

"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAD"

or if i could remove those semicolons in my Power Apps application 

thanks in advance  

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @Yazeed_Ablan :

I assume there is a string and you want to delete the first ';' and last ',' as shown below:

vbofengmsft_0-1646377921426.png

 


With(
    {
        DeleteLastComma:
        Concat(
          FirstN(
            Split("da;ta:image/png;base64,iVBORw0KGgoAAAANSUhEUg,AAD",","),
            CountRows(Split("da;ta:image/png;base64,iVBORw0KGgoAAAANSUhEUg,AAD",","))-1
          ),Result,",")&
        Last(Split("da;ta:image/png;base64,iVBORw0KGgoAAAANSUhEUg,AAD",",")).Result
    },
    Replace(
      DeleteLastComma,
      Find(
         ";",
         DeleteLastComma
      ),
      1,
      ""
    )
)

vbofengmsft_1-1646378716951.png

Best Regards,

Bof

 

View solution in original post

2 REPLIES 2
PabloRoldan
Resolver I
Resolver I

Hi you could create a power automate flow for remove those semicolons

 

create a flow like this

PabloRoldan_1-1646292433279.png

Text = input

TextOut = your text input using the function replace.

e.g: replace(triggerBody()['text'],';','')

 

Then,

call it with a button click or any action you need(here on a button click)

Set(textout,RemoveSemicolon.Run(TextInput1.Text))

PabloRoldan_0-1646292398056.png

regards

v-bofeng-msft
Community Support
Community Support

Hi @Yazeed_Ablan :

I assume there is a string and you want to delete the first ';' and last ',' as shown below:

vbofengmsft_0-1646377921426.png

 


With(
    {
        DeleteLastComma:
        Concat(
          FirstN(
            Split("da;ta:image/png;base64,iVBORw0KGgoAAAANSUhEUg,AAD",","),
            CountRows(Split("da;ta:image/png;base64,iVBORw0KGgoAAAANSUhEUg,AAD",","))-1
          ),Result,",")&
        Last(Split("da;ta:image/png;base64,iVBORw0KGgoAAAANSUhEUg,AAD",",")).Result
    },
    Replace(
      DeleteLastComma,
      Find(
         ";",
         DeleteLastComma
      ),
      1,
      ""
    )
)

vbofengmsft_1-1646378716951.png

Best Regards,

Bof

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,654)