Re: MySQL-csv insert into tables doesn't take effect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



M E Fieu wrote:
Hi.. I create a data.csv file using excel file and
convert to CSV as following

[root@box root]# more data.csv
departmentID,name,job
1,IT,IT-infra
2,HR,Human Resource
3,Finance,Financing


I just tried creating a csv file and convert it via dos2unix. For some reason the separator in my file looks different.

apprich@elmstreet org_pl $ dos2unix ~/Mappe1.csv
dos2unix: converting file /home/apprich/Mappe1.csv to UNIX format ...
apprich@elmstreet org_pl $ less ~/Mappe1.csv
1;a
2;b
3;c
4;d

Could you try it with ";" as separator instead of "," ?!
Other than that, can't help ya, sorry

[snip]

Alex


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux