Question

Asked on 2006-01-11 at 15:11:35ID: 25188433

Only Display String Right of Character

by: Ethx125

Rating9.6Excellent

I have a field on a report that is (from SQL) a concatenated string of two columns; separated by a semicolon (this is for sorting purposes).  I need a way to ONLY display what is on the right-hand side of the semicolon...essentially surpressing anything to the left (and including) the semicolon.

I'm using Crystal XI.

Thanks in advance!

  1. Conversions -  String to Number
    I'm in the process of troubleshooting an error th…
  2. Displaying Image in report
    I have a table which has a field listing the FILE N…
  3. Date vs. Date/Time Parameters
    Several of the Date fields in our database are Da…
  4. subreport shows wrong data while within main r…
    My record selection formula in main report is: …
  5. Establishing January 1st in a formula.
    Hello, I'm working on a few financial repor…

Solution

Access this solution immediately by signing up as a member of CrystalReportsExperts.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution

Sign up Now to View This Solution
Zone
general
Tags
string character crystal right
Participating Experts
2
Solution Grade
A

Replies

 by:

Posted on 2006-01-11 at 15:16:28ID: 26797931

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Ethx

Posted on 2006-01-11 at 15:21:17ID: 26797932

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: ladylinet

Posted on 2006-01-17 at 13:34:49ID: 26797933

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Stay Connected

Top Experts

  1. mlmcc

    334,774

    Wizard

    0 points yesterday

    Profile
  2. James0628

    70,696

    Master

    0 points yesterday

    Profile
  3. LinInDenver

    4,800

    0 points yesterday

    Profile
  4. peter57r

    4,000

    0 points yesterday

    Profile
  5. 13598

    3,520

    0 points yesterday

    Profile
  6. PCIIain

    1,700

    0 points yesterday

    Profile
  7. RickIsWright

    400

    0 points yesterday

    Profile
  8. Dan3D

    300

    0 points yesterday

    Profile

BrowseAre you an Expert?