Could someone please help me to extract a part of a URL an put it in to a new one.

In this URL I want extract the youtube videoID, and it is located at the end after = operator in blue:
https://www.youtube.com/watch?v=X2k1EOpC6Mk

The new URL would be:
http://img.youtube.com/vi/X2k1EOpC6Mk/maxresdefault.jpg

I think about a calculation field with the extracted value in between, something like:

"http://img.youtube.com/vi/"& extractedfromURL_field & "/maxresdefault.jpg"

 I am not sure how you extract the videoID.

Thanks!
 

Edited February 4, 20179 yr by snekkis

Use this calculation:

Let(
[~getID = Substitute(YourURLField; "="; "¶");
~gotID = GetValue(~getID; 2)];
"http://img.youtube.com/vi/"& ~gotID & "/maxresdefault.jpg"
)

 

If the string before the video ID is constant, you can simply substitute it with the new URL and append the filename to the result:

Substitute ( URL ; "https://www.youtube.com/watch?v=" ; "http://img.youtube.com/vi/" ) & "/maxresdefault.jpg" 

 

Otherwise you can use:

Right ( URL ; Length ( URL ) - Position ( URL ; "=" ; 1 ; 1 ) )

to extract the substring after "=" from the URL, and use it as:

Let (
id = Right ( URL ; Length ( URL ) - Position ( URL ; "=" ; 1 ; 1 ) )
;
"http://img.youtube.com/vi/" & id  & "/maxresdefault.jpg"
)

to get the final result.

Thanks for the exhaustive answers