Improve company productivity with a Business Account.Sign Up

x
?
Solved

Left and Right Trim a field in Crystal Report

Posted on 2016-08-31
2
Medium Priority
?
1,205 Views
Last Modified: 2016-08-31
Hello,

I have a data field in my Crystal report displaying the following:

COSS00385<XXXXXXXXXXXXXXX

How can I left and right trim this field so it only displays:

SS00385

Thank you
0
Comment
Question by:jspc
2 Comments
 
LVL 55

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 41777668
Hi,

pls try

MID({FIELD1.NAME}, 3, 7)

Open in new window

Regards
0
 

Author Closing Comment

by:jspc
ID: 41777674
Awesome! Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question