Ask Your Question

How do I extract the last part of a url?

asked 2019-02-18 16:07:10 +0100

rickn gravatar image

I have a column that looks like this: I only need this information which is the last par of the file name: 987611480.jpg Thank you so much if you can help me solve this problem.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-18 16:23:57 +0100

Grantler gravatar image

You may use the FIND&REPLACE tool. Activate Regular Expressions.

Search: ^.*\/([:digit:]+\.jpg)$

Replace (all): $1

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-18 16:07:10 +0100

Seen: 30 times

Last updated: Feb 18