i have a file(CSV) and the contents are:
Data A,,,,DATA B,,
,,7/12/2007,,,,7/12/2007
,,1:00,,,,1:00
NAME,REGION ID,Prices,,NAME ,REGION ID,Prices
(RESOURCE ID),,(QUANTITY) ,,(RESOURCE ID),,(QUANTITY)
AORT,6,"4,153.4 0",,TRIBU,3,"4, 153.40"
BIGTH,2,"4,067. 08",,YLUJ,1,"4, 056.45"
STRT,9,"4,067.0 8",,TSLO,8,"4,0 56.45"
Situation:
i want to store all of this strings to MySQL except for the bold ones.
how can i place my pointer in line number 5?
badly needed please help thanks.
Data A,,,,DATA B,,
,,7/12/2007,,,,7/12/2007
,,1:00,,,,1:00
NAME,REGION ID,Prices,,NAME ,REGION ID,Prices
(RESOURCE ID),,(QUANTITY) ,,(RESOURCE ID),,(QUANTITY)
AORT,6,"4,153.4 0",,TRIBU,3,"4, 153.40"
BIGTH,2,"4,067. 08",,YLUJ,1,"4, 056.45"
STRT,9,"4,067.0 8",,TSLO,8,"4,0 56.45"
Situation:
i want to store all of this strings to MySQL except for the bold ones.
how can i place my pointer in line number 5?
badly needed please help thanks.
Comment