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.
kelsanitAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieAnalyst Assistant Commented:
Can't you use the Left function?

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

If so, right(<yourfield>, 6) will do.
0
NorieAnalyst Assistant Commented:
Oops, didn't fully read the example - of course it should be Right not Left.
0
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
0
NorieAnalyst Assistant Commented:
Then use Mid without the length argument.

Mid({yourfield}, 7)
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.