Crystal - Left value until specific character

Crystal formula LEFT - I am trying to return the value LEFT until it find "EA".  I have the below formula but not working.  Using example below, I want to return KEL9400

KEL9400EA

Left ({FLCMaster.ProductID}, instr({FLCMaster.ProductID},"ea")-1)
kelsanitAsked:
Who is Participating?
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Split({FLCMaster.ProductID}, "ea")[1]
1
 
kelsanitAuthor Commented:
this is working when "ea" but some are "EA" and this formula is not picking those up. Is there a way to include both options in this formula?
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Use Replace() to replace "EA" with "ea" and apply the same logic as above.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.