I have data in a text file that have value like this :
      
      _______________________________________
      |id|name_item                   |value|
      _______________________________________
      | 1|Luas Bangunan               | 200 |
      | 2|Listrik, Air dan Air Bersih | 300 |
      | 3|Akademik (S1,D1,dan D3)     | 100 |
      _______________________________________

I've already try to import it to mysql and save it as csv but the result is :

      _____________________________________________________
      |id|name_item                   |value               |
      ______________________________________________________
      | 1|Luas Bangunan               | 200                |
      | 2|Listrik                     | Air dan Air Bersih |
      | 3|Akademik (S1                | D1,dan D3)         |
      ______________________________________________________

Anyone, How to solve this? 


Update : I've already got the solution for this topic, I change "," delimiter to pipe delimiter.

Thanks everyone :)