Hello, I'm trying to create a rule that removes the base URL and

issamd over 9 years ago

Hello,

I'm trying to create a rule that removes the base URL and only takes what is left afterwards.

I know the rule to get the base URL in the first place, how do I use this to get everything after it?

Example:

URL is www.appian.com/INeedHelp

So I want to extract just the INeedHelp.

Thanks!...

Discussion posts and replies are publicly visible

0 Zainab Benchekroun
Appian Employee
over 9 years ago

Have you tried using the right function as follows?
right(ri!url,len(ri!url)-len("www.appian.com/"))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 issamd over 9 years ago

It looks like that should work, thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

You can also use the split function:

=index(split("www.appian.com/INeedHelp","/"),2,"")

=index(split("www.appian.com/.../"),4,"")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 issamd over 9 years ago

Thank you, Eduardo. Zainab's suggestion worked well because the URL I am dealing with has multiple /'s.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel