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

4
  • 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
    Commented Jul 18, 2016 at 3:41
  • What tool are you using to import?
    – Philᵀᴹ
    Commented Jul 18, 2016 at 7:47
  • @Phil I use mysql front and openoffice Commented Jul 18, 2016 at 8:09
  • With what options? What does the data file look like?
    – Rick James
    Commented Jul 18, 2016 at 23:21

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.