Forum Discussion

NurAmirah_MY's avatar
NurAmirah_MY
Regular Visitor
2 years ago

Split by comma into row

Hi, I have set of data and want to split by comma into row. However, some of of the text that has comma I want to keep it as it is, which means no need to split.  eg: Data I have --> I enjoy sw...
Need Help
NurAmirah_MY's avatar
NurAmirah_MY
Regular Visitor
2 years ago

Hi PijushRoy 

 

Thanks for the solution. I have tried but the word with , that I want to keep still splitting. I have replave value of "," with "#" 2 times and split by row.

 

I'm not sure what went wrong. Let me repharse the example:

 

eg: Data I have --> Trust,Happiness, enjoyment and excited,pessimistic, optimistic 
Data I want it to be by row:

Trust

Happiness, enjoyment and excited

pessimistic 

optimistic

 

Does the same solutiom applied? Thanks.