Hi Guys,
I am trying to achieve the task here which is:
for example if the data coming from column 'Response' is : abcde; fghijkl 1234
Then it must populate in cells at header of report based on position of semicolon i.e. if there 1 semicolon then it must populate in 2 cells
abcde (1st cell)
fghijkl 1234 (2nd cell)
and if there are 2 semicolons then the data after the 2nd semicolon must come in the 3rd cell.
abcde;fghijkl;mnopqrst
then the last string must come in 3rd cell
abcde (1st cell)
fghijkl 1234 (2nd cell)
mnopqrst (3rd cell)
I have read many blogs and tried several ways on this but havent got any solution. Please suggest the solution on this.
Thanks
Vaibhav