Substitute minus 1

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I want to read into PowerApps files that may look like this:

Nr.5.3.10.03.1959.bla.pdf.

I now want to change the file name so that it contains only one dot, so then like this: Nr5310031959bla.pdf

But the number of dots can vary.

I try with different commands to solve the problem (Replace, Substitute, ForAll, Split etc.), but I don't get a solution.

Does anyone here give me an idea ?

Regards

Herb

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Substitute("Nr.5.3.10.03.1959.bla.pdf",".","")
This will Remove dots however it will also remove dot before pdf, if this works for you use this!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Manan-Maolhotra,
thank you for the quick feedback.
But with your example all points are deleted.
But I still need the dot in front of the file extension (i.e. x.pdf), otherwise the file is no longer valid.

Regards
Herb

Was this reply helpful? Yes No
Manan-Malhotra 621 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Substitute(Left("Nr.5.3.10.03.1959.bla.pdf",Len("Nr.5.3.10.03.1959.bla.pdf")-4),".","")&".pdf"

Use this then, hope this helps

You can use a label for the name here "label.Text"

@Anonymous
Please Accept as Solution if it solves your question Or just give it a Thumbs Up if it is helpful because this can help others.
LinkedIn: https://www.linkedin.com/in/manan-malhotra-vfx/
Want to support me! Buy me a Cup of Coffee?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The PDF file was only an example, it could also be an office document, e.g. x.docx or x.xlsx.
Then the with - 4 does not work anymore 🤔

Was this reply helpful? Yes No
Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @Anonymous ,
please find formula as below:

Concatenate(Concat(Remove(Split("Nr.5.3.10.03.1959.bla.pdf","."),Last(Split("Nr.5.3.10.03.1959.bla.pdf","."))),Result),".",Last(Split("Nr.5.3.10.03.1959.bla.pdf",".")).Result)

Want To Support me? Buy me a Coffee

Was this reply helpful? Yes No
fuzzy_fuzz 229 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous

Maybe using collections to separate the file extension would work.

I made this:

ClearCollect(collection, Split(Label19.Text, ".")); Set(varExtension, Last(collection).Result); Remove(collection, Last(collection));

Then concatenate everything

Concat(col,Result) & "." & varExtension

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

hI @theapurva;
great, that's how it works. Thanks a lot for your help.

Regards
Herb

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @fuzzy_fuzz,
Thank you for your tip, but I have already decided to use the solution of @theapurva

Regards
Herb

Was this reply helpful? Yes No