How to remove specific Characters from a URL

[Venamma]

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

[binuacs]

@Venamma @Try the below formula

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

[binuacs]

Edit:

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