2 Replies Latest reply: May 15, 2014 10:04 AM by Grant Perkins RSS

    LSplit on quote?

    joe.lovati _

      I'm trying to perform the LSplit function using " as the seperator.  Is this possible or is there another way to seperate just the User.Name information. 

       

      Detail example

      Logged into "User.Name"

        • LSplit on quote?
          Olly Bond

          Hello Joe,

           

          You can - lsplit(field;3;chr(34);2) should do the trick.

           

          chr(42) for * is another useful one to remember.

           

          Best wishes,

           

          Olly

          • LSplit on quote?
            Grant Perkins

            I'm trying to perform the LSplit function using " as the seperator. Is this possible or is there another way to seperate just the User.Name information.

             

            Detail example

            Logged into "User.Name"[/quote]

             

            Joe,

             

            Not sure what version you are using but another way would be rsplit on the space, giving "User.Name", and then strip the "s and do any trimming that may be appropriate.

             

            However Olly's suggestion may be better for you in this example.

             

             

            Grant