Post reply

Split function

  • November 29, 2007 at 1:47 pm

    #184509

    I can't get the syntax right for a split function.

    I want to split the following field to separate lines in the report:

    004 - Grades 1 Through 8*010 - Business, Grades 7 Through 12*

    The * is the delimiter.

    I tried this:

    =Split(Fields!EndorseType.Value, "'*'",-1,1)

    Thanks for your help.

  • November 29, 2007 at 2:16 pm

    #755689

    That syntax looks correct. What result are you getting?

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]

  • November 30, 2007 at 7:26 am

    #755949

    I get #ERROR in the report where I want the data displayed.

    Thanks.

  • December 3, 2007 at 10:24 am

    #756572

    I wonder if it just doesn't like * as a delimiter, trying to multiply something. Can you change it to something more traditional like a comma?

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]

  • December 4, 2007 at 6:24 am

    #756896

    Tried that. Same error.

    Thank you.

  • December 4, 2007 at 9:02 am

    #757001

    I copied out your sample, and got single quotes (') around the *. Try removing that.

  • December 4, 2007 at 9:17 am

    #757020

    Split returns an array. Maybe you can't put the results into a text object.

  • December 4, 2007 at 9:21 am

    #757026

    Of course, good catch!

    Try instead replacing the "*" with a CRLF.

    P.S. What was the target object by the way?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply