Remove extraneous characters from beginning of field

[-dp-]

I have to work with imported data that consistently follow this pattern.

tbn:ANd9GcRd4fVcExYeQOa4L3AahyuyAh4rlLfaKuHd6EWJZAlcKSUYVJS7IcugGE1impKxwfJDTvU:https://get.pxhere.com/photo/food-natural-foods-whole-food-Food-group-superfood-cuisine-local-food-vegetable-ingredient-dish-vegan-nutrition-produce-vegetarian-food-delicacy-still-life-meal-recipe-herb-still-life-photography-1621684.jpg

The field contents aways begin with tbn, followed by a colon.
An apparently random string follows, always ends with a colon.
There are never any colons in the string (except at the beginning and end).

The URL follows the second colon.

I need to create a calculation that ignores everything before http. I'm guessing it involves Right and Position, but so far, I can't get anything to work. Can someone help?

Thanks,
dp

[comment]

6 minutes ago, -dp- said:

There are never any colons in the string (except at the beginning and end).

There is a 3rd colon immediately after https . Anyway, you can choose to remove the part that ends with the 2nd colon, or extract the part that starts with http . Here's an example that does the former:

Let ( [
end = Position ( YourField ; ":" ; 1 ; 2 )
] ;
Replace ( YourField ; 1 ; end ; "" )
)

 

 

[-dp-]

That worked. Thank you.