Ask Your Question
0

How do I extract the last part of a url?

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

rickn gravatar image

I have a column that looks like this:https://dqzrr9k4bjpzk.cloudfront.net/images/13505408/987611480.jpg 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
0

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

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

Stats

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

Seen: 32 times

Last updated: Feb 18