Trim String at both ends

[DHB]

I'm trying to trim a test string to retain a number from the middle.  The number has varying amounts of digits.

So 

/courses/12345/users/69565/usage?page=3&per_page=100

Becomes...

69565

The number in the middle will always be preceded by '/users/' and followed by '/usage'.

Any suggestions will be gratefully received.

Best,

DHB

[JoshKushner]

You can use the Text to Columns Tool to split the string by the delimiter '/' then by the delimiter '?'. Then use a Multi-Row Formula Tool to find the data point that follows your requirements (preceded by 'users' and followed by 'usage').

I've attached a sample workflow.

Flow:

Result:

Text to Columns:

Multi-Row Formula:

[vishwa_0308 · Accepted solution]

Hi @DHB,

You can try this specific solution for ur query : To get the numbers between '/users/' and '/usage'.

[DHB]

Thank you both for your solutions.  I've gone with the 1 tool workflow for simplicity and it does exactly what I need.