Finding info / Splitting to columns based on delimter?

[Libby]

Hello all, 

I'm hoping for some help with formulas that will allow me to achieve below. I have scoured all the brilliant responses to similar questions, but none quite meet with this. 

The format will always be the same but character lengths with vary. Also, the final .pdf that I am excluding may sometimes be a different file format. 

[kuovonne]

I suggest you look into the REGEX (regular expression) functions. I also recommend that you use an online REGEX tester with several different examples that span the entire range of sample data. I have seen posts where someone provides and single example and someone volunteers a regular expression, and then the original poster provides additional examples where the regular expression doesn't work, requiring reworking the regular expression. It is better to have the full range of possible values up front.

[Libby]

Thanks, yes, I have read many posts of this kind and spent many hours exploring the different REGEX functions prior to asking for help. I cant make it work