Subfield with multiple characters.

[LehiVitor]

I have several parts number that ends in '-S' put will also have a '-S' in the character string. I'm looking to only separate the '-S' at the end of the string - E71=L-S-B-S to E71=-L

I've tried using the Subfield functions but that will only return the characters left of the first '-S' -> "E71=L"

Does anyone know how I might be able to return E71=L-S-B?

[sunny_talwar · Accepted solution]

Try this

=Left([Part Number], Index([Part Number], '-S', -1)-1)

[LehiVitor]

Thanks Sunny, that worked!