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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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