I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

Like (0) Share

Report

Posted on 27 Sep 2021 20:53:06 by golfnutt82

1,360

If I have a URL string that looks as follows

can I extrapolate all characters (but no longer than 14) to the right of the last forward slash.

Is this possible?

All responses (5)

Answers (1)

abm abm 32,506 Most Valuable Professional on 27 Sep 2021 at 23:06:03

Like (0)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

Hi @golfnutt82

Another way to do this is as follows:

Above expressions are:

last(split(outputs('Compose'),'/'))

substring(outputs('Compose_3'),0,if(greaterOrEquals(length(outputs('Compose_3')),14),14,length(outputs('Compose_3'))))

Thanks
abm abm 32,506 Most Valuable Professional on 27 Sep 2021 at 22:49:03

Like (1)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

You didn't mentioned earlier that you could have less than 14 characters length as well.

First find the last string after the last slash

last(split(outputs('Compose'),'/'))

The above expression will give you the string

Then add an If condition to check the length is less than 14 by comparing the above value.

If its more than 14 then use the expression which I mentioned earlier substring(last(split(outputs('Compose'),'/')),0,14) else use the expression last(split(outputs('Compose'),'/'))

Thanks
golfnutt82 1,360 on 27 Sep 2021 at 21:53:20

Like (0)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

So in the URL there is only 8 characters but I need the system to allow for up to 14 characters.
When I saw you expression I was very excited because I had not thought of using what you did!
Awesome, you did a test on your end and didnt receive an error like I show?
Verified answer

abm abm 32,506 Most Valuable Professional on 27 Sep 2021 at 21:38:22

Like (1)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

Hi @golfnutt82

Here it is

Expression for the above is as follows:

substring(last(split(outputs('Compose'),'/')),0,14)
abm abm 32,506 Most Valuable Professional on 27 Sep 2021 at 21:38:20

Like (0)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

Hi @golfnutt82

Here it is

Expression for the above is as follows:

substring(last(split(outputs('Compose'),'/')),0,14)