Forum Discussion

utsavlexmark's avatar
utsavlexmark
Helper III
3 years ago

Search A Particular Term in Column Value

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

Need Help
Tips and Tricks

1 Reply

  • JadhavVarsha_13's avatar
    JadhavVarsha_13
    Helper V
    3 years ago

    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