Search A Particular Term in Column Value

[utsavlexmark]

Hello,

I am working with a data where a Particular Column is containing URL in it. Now my requirment is; I will look for the end term of the URL and return a value for it.

Suppose if the URL is ending with "/en_us.html" or "/en_gb.html" or "/fr_fr.html" etc -  it will return "Home Page".

Any suggestion on how to do this will be a great help for me.

Please let me know if any further information required.

Regards

Utsav

[JadhavVarsha_13]

Hello @utsavlexmark 

You can try this, 

Add Column 

Column Name = IF(OR((RIGHT(Table Name[URLColumn],11)="/en_gb.html"),(RIGHT((Table Name[URLColumn],11)="/en_us.html")),(RIGHT((Table Name[URLColumn],11)="/fr_fr.html")),"Hiome Page","Else ")

Or you can use find and look for / and extact the text post / and then use IF and OR for URL extentions