• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

Crystal Reports Left MID O or ?

I have item codes in my system that begin with "SS" I need strip the SS of the item code.
How can I do this?

Examples:

SSATC
SSATG
SSATL
SSBSBBM
SSBSBBMANG
SSBSBBMILK
SSBSBBPOM
SSBSBLHW
SSBSERM
SSBSFSM
SSBSFTMC
SSBSFTMR
SSBSHLGRE
SSBSHLLAV
SSBSHLMANGO
SSBSHLMIL
SSBSHLPOM
SSBSHLU
SSBSMBBP
SSBSMBBPGRE
SSBSMBBPLAV
SSBSMBBPMANG
SSBSMBBPMILK
SSBSMBBPPOM
SSBSRLO
SSBSTP
SSCOCO
SSCOCOBALM
SSCONTROLGLIDE
SSCRO
SSDPC
SSDTU
SSHBBC
SSHBFC
SSHBG
SSHSBO
SSHSC
SSHSFA
SSHSFO
SSINTROPK
SSMJTMC
SSMJTMG
SSMLBLI
SSMLCAL
SSMLENE
SSMLREW
SSMLSER
SSNNC
SSNNL
SSNNO
SSPL
SSPTOMC
SSPTOMG
SSROU
SSRTMC
SSSTP
SSTBG
0
Scott Johnston
Asked:
Scott Johnston
  • 2
1 Solution
 
mlmccCommented:
Assuming they allstart with SS

Mid({YourField},3)

If some don't start with SS
If Left({YourField},2) == "SS" then  
   Mid({YourField},3)
Else
   {YourField}

mlmcc
0
 
Scott JohnstonSystems ConsultantAuthor Commented:
Thank you
0
 
Scott JohnstonSystems ConsultantAuthor Commented:
worked
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now