Skip to Content
avatar image
Former Member

splitting a string

Dear all,

             I have to split a string on four parts, how can i use it. 401040302\PCA\CA-PR-E008-14\1234   i want to split this into four parts based on delimiter.

1. 401040302

2.PCA

3. CA-PR-E008-14

4.1234  

please let me know the formula..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 11, 2015 at 11:23 AM

    Hi Akram,

    The formula to show the first part of the string would be:

    Split({Database_field}, "\")[1]

    To show the second part, it would be:

    Split({Database_field}, "\")[2]


    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Abhilash,

                           I got the result. Thanks for the help. I just need one more help in the same regard.

      In my array some times we will not have 401040302\PCA\\1234 the third value.  Then the report throws error. Can i assign value like

      1- glaccount

      2-division

      3- project

      4- employee

      Regards,

      akram