Jump to content
snekkis

How to Extract videoID in URL

Recommended Posts

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 by snekkis

Share this post


Link to post
Share on other sites

Use this calculation:

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

 

Share this post


Link to post
Share on other sites

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.

  • Like 1

Share this post


Link to post
Share on other sites

Thanks for the exhaustive answers :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

By using this site, you agree to our Terms of Use.