In message <t$I57IA7x8eKFwEH@xxxxxxxxxxxx>, Pete <cgrp@xxxxxxxxxxxx> writes >In message <697048.32920.qm@xxxxxxxxxxxxxxxxxxxxxxxxxxx>, Reji Jayan ><for_rejijayan@xxxxxxxxxxx> writes >> >>What they gave is an ftp account ..within that few " text files " >> >>which is the product details, brand, location .. >> >>for confirmation this is line from a text, >>-------------------------- >> >>"000010" "Metolius, Nylon Handle w/Rubber Overmold, >>Guthook" "013658111752" .500 >>0 "Metolius" "GERBKN" "" "B" "" 2009-01-27 00:00:00 "GERBER" "KNIVES" "NO" "NO" >> >>"NO" "NO" "NO" 50.00 25.00 0.00 "FOL" "CHN" "31-000010" >> >>-------------------------- >> >> >>Thank You, >> >>Reji, >>PHP Developer. >>================== > >Well, it's not CSV - that stands for COMMA Separated Variables, and >there isn't a comma in sight! > >Could there be tabs in between the fields? > >Anyway, there is a mistake. >>"B" "" 2009-01-27 00:00:00 "GERBER" > >Either - there is an empty field after "B", which is quote possible, in >which case there are no commas around the date >"B" "" "2009-01-27 00:00:00" "GERBER" > >Or one of the commas before the date should be behind it >"B" "2009-01-27 00:00:00" "GERBER" > >You didn't answer my question. Can you reach the file with a browser? What I *meant* to say was... *************** Either - there is an empty field after "B", which is quite possible, in which case there are no quotes around the date "B" "" "2009-01-27 00:00:00" "GERBER" Or one of the quotes before the date should be behind it "B" "2009-01-27 00:00:00" "GERBER" *************** But the question is still outstanding >You didn't answer my question. Can you reach the file with a browser? -- Pete Clark Hot Costa - Local Spain http://www.hotcosta.com
