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.

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

what's the difference between the comma after "Happiness" and "pessimistic"?

  • NurAmirah_MY's avatar
    NurAmirah_MY
    Regular Visitor
    2 years ago

    The comma after "Happiness" has a space. The comma after "Pessimistic" don't has a space.