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
Solved! Go to 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
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
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
User | Count |
---|---|
252 | |
125 | |
106 | |
50 | |
49 |