topic Extracting data from URL in App Development

Extracting data from URL

Nagaraj6 — Fri, 15 Nov 2024 21:52:29 GMT

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,

Re: Extracting data from URL

justISO — Tue, 25 Apr 2023 08:46:14 GMT

Hi, how about something like this:

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

Re: Extracting data from URL

Nagaraj6 — Tue, 25 Apr 2023 09:27:39 GMT

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

Re: Extracting data from URL

MayilVahanan — Tue, 25 Apr 2023 09:32:06 GMT

Try like below

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