Answered

PowerApps remove last part of string

(0) Share

Report

Posted on by Krentor

Hello,

in PowerApps forms, i have a string /sites/SkoleniSFRB/Reporty/DataSP/01.jpg. I need to remove part 01.jpg so string remains.

Can please someone help me?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

TheRobRush 11,128 Moderator on at

Like (1)

Report
where Label10 is our string

Concat(FirstN(Split(Label10.Text,"/"),CountRows(Split(Label10.Text,"/"))-1),Result,"/")&"/"

Was this reply helpful? Yes No
JmeBrey 55 on at

Like (1)

Report
Yes , a few ways to achieve this - you will have to select which is the best option for you, for example if the string can end with different file names, you may need to adjust the formula accordingly.

Substitute("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", "/01.jpg", "")

Replace("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", Right("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", 6), "")

This formula uses the "Right" function to extract the last 6 characters (which is the length of "01.jpg"), and then uses the "Replace" function to replace those characters with an empty string, effectively removing them from the original string

Left("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", Len("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg")-6)

This final one is good if you want to remove everything after the last "/" regardless what the text is
Concat(Split("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", "/"), "/", CountRows(Split("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", "/"))-1)

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

Use the method I outlined in my response, it will work regardless of the file name, or length of rest of fullpathname etc.

Was this reply helpful? Yes No
Krentor 70 on at

Like (1)

Report

Thank you very much! That helped me. Love this community.

Regards,
Jakub

Was this reply helpful? Yes No