Left Mid Find Functions

[leewayn1]

Hello Everyone,

First time poster here so please bear with me. I am trying to extract a portion of text from a string and was wondering if anyone can help me out. I have the following strings

Jon.Mathan (312345) » Video (893481) » Gallery (1239814)
Dog.day (251654) » video_preroll (23918475)
MobileApps (new ad unit) (45917839) » en-CA (2938754) » news (1924785)

I want to get the middle text from each of these so I get

Video
video_preroll
en-CA

I've tried creating two additional columns with the first using the following formula

=MID(B10,FIND("» ",B10,1),7) = » Video, » video, » en-CA

Then i tried to extract the remaining text using a right function but the video_preroll isn't working.

Anyone have an idea?

 

[leewayn1]

Just need the original 750,000 rows with the specified level 1, 2 and 3 strings separated. Know of any other solutions?