Forum Discussion
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 swimming,I enjoy reading, I enjoy hiking, exploring and walking.
Data I want it to be by row:
I enjoy swimming
I enjoy reading
I enjoy hiking, exploring and walking
How can I have such data? Thanks
7 Replies
Hi NurAmirah_MY
You needs to two times replace value as space are not consistent in text
Step 1 Replace ValueStep 2 - Replace value
Then Split
https://drive.google.com/file/d/1yV31w4lgjBBkFXymCQ9AV4yJM3Uk6OuB/view?usp=sharing
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks
PijushHi 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.
what's the difference between the comma after "Happiness" and "pessimistic"?
