Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this
=Left([Part Number], Index([Part Number], '-S', -1)-1)
Thanks Sunny, that worked!