Crystal - Mid function - Return everything after Left 6 length

Crystal - Need to return all data that is Left, 6 of the string.

Example:  227800kc04142

I want to return "KC04142"

I have found several MID functions but non based on length.
Who is Participating?
NorieConnect With a Mentor VBA ExpertCommented:
Then use Mid without the length argument.

Mid({yourfield}, 7)
NorieVBA ExpertCommented:
Can't you use the Left function?

Left({yourfield}, 6)
Raghavendra HullurSoftware DeveloperCommented:
Hi as per your example, you need 6 characters which are on right most

If so, right(<yourfield>, 6) will do.
NorieVBA ExpertCommented:
Oops, didn't fully read the example - of course it should be Right not Left.
kelsanitAuthor Commented:
I cannot do that because sometimes the length of the items I want to pull is different.  The only length that is consistent is left, 6  which is why I was trying to do formula that would return everything left of the field after position 6

here are two example:
227800kc04142   value returned kc04142
202960fj894202 value returned FJ894202
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.