Thanks for the reply, but do I necessarily need to use php? I'd like the
ability to do it from the SQL command window using a variation of the
.import command, if possible.
Kit-18 wrote:
>
> 2012/1/9 rpallotta <evilspambuc...@gmail.com>:
>>
>> I need to import a file to a table but there are two delimiters used in
>> the
>> file; quotes and spaces. The first 2 columns are for metadata and use
>> quotes, the remaining columns are financial data (a column for each
>> month)
>> separated by spaces. For example:
>>
>> "Net Sales" "New York" 1000.00 999.00 1112.00
>> "Expenses" "New York" 555.00 600.00 500.00
>
> <?php
> $f = fopen("example.csv", "r");
> $data=fgetcsv($f, 1000, " ");
> print_r($data);
> ?>
>
> [0] => Net Sales
> [1] => New York
> [2] => 1000.00
> [3] => 999.00
> [4] => 1112.00
> --
> Kit
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Import-File-with-Mixed-Delimiters-tp33107824p33113156.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
