AnsweredAssumed Answered

Calculation troubles

Question asked by SkipGilleland on Apr 25, 2014
Latest reply on Apr 25, 2014 by philmodjunk

Title

Calculation troubles

Post

     I am trying to parse a URL out of some content on one field to have it entered into another field.  The URLs are for videos..some are hosted on you tube and some are hosted on Wistia.  I would like to use the following...start from [src="] and end at ["]

Example of calculation I am trying to use:

     Middle ( 
     post_content ;
     Position ( post_content ; "src" ; 1 ; 1 ) ; 
     Position ( post_content ;  ' " '  ; 1 ; 1 )-Position ( post_content ; "src" ; 1 ; 1 )
     )
      
     I am getting an error stating "The specified field cannot be found." and it is highlighting the ' " "
      
Example of content I am trying to parse from: (example from youtube and wistia)

          <iframe src="http://www.youtube.com/embed/_EXwruyLHIs" height="360" width="640" frameborder="0"></iframe>

          <iframe name="wistia_embed" src="//fast.wistia.net/embed/iframe/h9lu36abmu" height="360" width="640" allowfullscreen="" frameborder="0" scrolling="no"></iframe>

      

Outcomes