(SUBSTRING( @[User::FileWeJustFound],79,3) == "HO\" ? SUBSTRING( @[User::FileWeJustFound],79,2) : (SUBSTRING( @[User::FileWeJustFound],79,3) == "HMR" ? SUBSTRING( @[User::FileWeJustFound],79,4) : SUBSTRING( @[User::FileWeJustFound],79,3))) Cheers David

Hi David, Your expression seems be right, what is the message error when click ok?Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

Attempt to parse expresstion ... failed. The expression might contain and invalid token, an incomplete token, or an invalid element. It might not be well formed, or might be missing part of a required element such as a parenthesis. This is when I try to evaluate it...

ahh ok you should change the SUBSTRING( @[User::FileWeJustFound],79,3) == "HO\" ... by SUBSTRING( @[User::FileWeJustFound],79,3) == "HO\\" The expression editor use the same escape characters than C#. You must insert one more back slash. Víctor M. Sánchez García (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

Brilliant - thanks you very much.

You're welcome!Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky