Extracting data from URL

[Nagaraj6]

Hello All,

I need a help

1)/holidays/india-tour-packages/cordelia-cruise-tour-packages/cordelia-cruises-mumbai-high-seas-cochin?pkgId=_cordelia cruise_CITY_0?destTag=Kerala

2)/holidays/india-tour-packages/rajasthan-tour-packages

condition:I want  india-tour-packages only in that extract the Destination .

Expected Output:cordelia-cruise

                            rajasthan

 I am using this formula not working :

SubField(Match([Page URL],'india-tour-packages'), '/', 4) as Dest,

[justISO]

Hi, how about something like this:

replace( SubField([Page URL], '/', 4) , '-tour-packages' ,'') as Dest

[Nagaraj6]

@justISO  Thank You!! It's Working.👍

[MayilVahanan]

Try like below

=TextBetween([Page URL],'/', '-tour', 3)