Fetching part of URL

[Pumpedplop]

So I have this problem that I have saved a series of URL's , but I need a specific part of said url (marked  in the picture).  I can not share the complete URL but the most left e you can see, is from the ".be" of the url. 

Does anyone know a solution?

(I can't do it manually because there are already 1300 entries)

[PotatoMato]

Hi @Pumpedplop. If you are trying to get the specific part of the URL you can use the formula field with text function: https://howto.caspio.com/function-reference/#:~:text=Integer-,Text Functions,-Function

 

You can also provide sample URLs from your table and your expected output so i can check.

 

-Potato

[CoopperBackpack]

Hello @Pumpedplop,

In case the URL always ends with '_.pdf' and those digits to be retrieved are always placed before this '_.pdf', please test the following formula:

REVERSE(SUBSTRING(REVERSE([@field:Company]), 6, CHARINDEX('_', REVERSE([@field:Company]), 6) -6))

Please replace the Company field with your field name.
For example:

Output:

[Pumpedplop]

Thank you, @CoopperBackpack

But I looked over the fact that sometimes the URL doesn't end on _.PDF but just .PDF, I tried fixing your code myself but it still didn't work.

Any fixes?

[Jodie]

So if you use the replace function, and change the starting value to 5 you should be able to make this work.

REVERSE(SUBSTRING(REVERSE(REPLACE([@field:test],'_.pdf','.pdf')),5, CHARINDEX('_',REVERSE(REPLACE([@field:test],'_.pdf','.pdf')),5)-5))

[Rohit4321]

Thanks for your kind information. It will surely give me important knowledge.