Skip to main content
added 124 characters in body
Source Link

SOLVED - How to import a text file with "," value to Mysql

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

How to import a text file with "," value to Mysql

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?

SOLVED - How to import a text file with "," value to Mysql

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

Source Link

How to import a text file with "," value to Mysql

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?