1

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

  • I think that you're going to somehow place double quotes into your file - maybe using sed (or Windows equivalent) or get your data feed to be with pipes (|). – Vérace Jul 18 '16 at 3:41
  • What tool are you using to import? – Philᵀᴹ Jul 18 '16 at 7:47
  • @Phil I use mysql front and openoffice – Tri Susanti Jul 18 '16 at 8:09
  • With what options? What does the data file look like? – Rick James Jul 18 '16 at 23:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.