Title
Need code to generate a constant URL plus a changing video name and location
Post
Good morning from LA,
I am looking for a code to generate URLs consisting of two parts:
A) http://xyz - this part will be constant, for every record
B) A part of the value of what is in our container fields. At the moment, I have a calculation field generating this value. It returns (for example):
size:640,360
movie:0117_00-00-20-20.mov
moviemac:/2A_HDCam/Downconverts/0117_Downconverts/0117_00-00-20-20.mov
Of this, I only need "Downconverts/0117_Downconverts/0117_00-00-20-20.mov". This part will change for every record, but will always be the same part of the value.
I think that a simple code will give me A plus the relevant part of B.
What I am doing, more broadly, is generating the URLs to movies located on our server. I have probably made this far more complicated than need be, and any advice to simplify would also be greatly appreciated.
Thanks all!
I'm interpreting this to mean you want all text to the right of the second / in the 3rd line of your container text.
Let ( line3 = GetValue ( YourTable::YourContainerField ; 3 ) ; "http://xyz" & Middle ( line3 ; Position ( line3 ; "/" ; 1 ; 2 ) ; 999 ) )
This should return: http://xyz/Downconverts/0117_Downconverts/0117_00-00-20-20.mov
in your example.