mysql - Changing .csv field separator using a PHP Script -


i'm working on script connect external ftp, download .csv file , import each record .csv table.

i've written script so, have 1 major issue. 1 of columns in .csv file description column which, guessed it, contains commas.

this description column wrapped in quotation marks (") i've read solution, column contains measurements, i'd have escape " well.

the easiest solution see change field separator uncommon, such | or ^. can tell me if can accomplished in php script? if has alternate suggestion, please let me know, direction here helpful!

thanks!


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -