2 Replies Latest reply on Oct 5, 2018 7:40 AM by venkatram

    Splitting the string when it is having both | and :

    Nishantha Bhaskar

      I have a field called year adjust which  has the following data 

                    year Adjust

                        2017:8

                        2018:7

                2017:5|2018:4

                2017:3|2018:6

                        2018:6

                        2017:6

       

      Now i want to make 2 column one for 2017 adjusted and another 2018 adjusted . when we try to split the data first we have to split based on pipeline first and then based on colon,

      i am getting an error "Error connecting to data source "

       

      Is there any way i can split the data and not get the error

       

      Thanks,

      Nishantha