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

(0) Share

Report

Posted on by golfnutt82

1,362

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?

Categories:

Building flows

All responses (5)

Answers (1)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @golfnutt82

Here it is

Expression for the above is as follows:

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

abm abm 33,004 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @golfnutt82

Here it is

Expression for the above is as follows:

substring(last(split(outputs('Compose'),'/')),0,14)
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
abm abm 33,004 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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