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.

/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

Preparation

Accepted answers

vishwa_0308

Hi @DHB,

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

All comments

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:

text to col 2.PNG text to col.PNG

Multi-Row Formula:

multi row formula.PNG

Trim String at both ends.yxmd

vishwa_0308

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703