2

I'm trying the below code to select the last part of the URL:

select 'http://www.XX.com/download/apple-Selection-products/beauty-soap-ICs' ,  field_1[0].string
from
(
select SPLIT('([^\/]+$)', 'http://www.XX.com/download/apple-Selection-products/beauty-soap-ICs')field_1 

  )

However, my result isn't coming as expected.

http://www.XX.com/download/apple-Selection-products/beauty-soap-ICs

result should be :

beauty-soap-ICs

but I'm getting Wrong Result.

Any help will be appreciated. The URL can and can't end in a /.

Wiktor Stribiżew
  • 607,720
  • 39
  • 448
  • 563
guess_work0205
  • 21
  • 2

1 Answers1

0

You can use the REGEXP function here:

SELECT REGEXP('http://www.XX.com/download/apple-Selection-products/beauty-soap-ICs', '.*/([^/]+)/?$', '$1') AS result

See the regex demo

Details:

  • .* - any zero or more chars other than line break chars as many as possible
  • / - a / char
  • ([^/]+) - Group 1 ($1 refers to this group value)" one or more chars other than /
  • /? - an optional / char
  • $ - end of string.
Wiktor Stribiżew
  • 607,720
  • 39
  • 448
  • 563