Remove semicolons in multiline text sharepoint list

[Yazeed_Ablan]

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  

[PabloRoldan]

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

create a flow like this

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))

regards

[v-bofeng-msft · Accepted solution]

Hi @Yazeed_Ablan :

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

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,
      ""
    )
)

Best Regards,

Bof