Text Parsing

[ddinisco]

I am trying to parse just the names out of the end of these lines. I have looked all of the text function and have not come up with any solution. Any help would be much appreciated.

#td class="nm"$#a href="/name/nm0001567/"$Connie Nielsen#/a$#/td$

#td class="nm"$#a href="/name/nm0001657/"$Oliver T. Reed#/a$#/td$

#td class="nm"$#a href="/name/nm0001321/"$Richard Will Harris#/a$#/td$

[mr_vodka]

If all of the paths are similar like this, then you can try something like:

Let ( x = Left ( textin; Position ( textin; "#/a$#"; 1; 1 ) - 1); 



Middle ( x; Position ( x; "/"; 1; PatternCount ( x; "/" ) ) + 3; Length ( x ) - Position ( x; "/"; 1; PatternCount ( x; "/" ) ) )



      )

[ddinisco]

Thanks John I will give that a shot.