Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to remove specific Characters from a URL

Venamma
7 - Meteor

Hi team,

 

I have a URL mentioned below, I would like to remove the characters til ".com/"and also remove the ".html?" and my result should look like

"t5/forums/postpage/board-id/designer-discussions"

 

 Example:

https://community.alteryx.com/t5/forums/postpage/board-id/designer-discussions.html?

Result:

t5/forums/postpage/board-id/designer-discussions

 

Can someone pls help me with this?

 

Regards,

Venamma

2 REPLIES 2
binu_acs
21 - Polaris

@Venamma @Try the below formula

 

Regex_Replace([URL],".*com\/(.*) \/.html\/?","$1")

binu_acs
21 - Polaris

Edit:

 

Regex_Replace([URL],".*com\/(.*)\.html\/?","$1")

 

image.png

Labels
Top Solution Authors