Crystal Formula Help - ID for text field

Need help with the following:

Create formula that will provide an ID to each value based on the following:

Product code (example  091000)  Field is always 6 character long
product pack code (example 1:  12BSL) (example 2: 12)  (Example 3: 41)

if product pack code is just 2 characters long then "NationalBrand" else
if product pack code contains "BSL" then "NationalBrand" else "PrivateLabel"
Who is Participating?
mlmccConnect With a Mentor Commented:
Try this

If (Length({YourField}) = 2 or Instr({YourField},'BSSL') > 0 then
    "National Brand"
    "Private Label"

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.