Skip to Content
0
Jan 24, 2023 at 03:26 PM

Splitting the data based on position of delimiter

249 Views

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