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 :)