Hi All after a bit of help on how to import data from a pastel accounting database into mysql, i also need to remove some lines out of the pastel txt file before importing into mysql
eg 1 "*PC\CC-ABS533 ","COMPUCON Abacus Celeron/Pentium PC ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","" has to end up with this data "*PC\CC-ABS533 ","COMPUCON Abacus Celeron/Pentium PC ",0 eg2 "NCHW\IQISW050R ","iNEQ Wireless BB Rou.& USB PrnServer ",218,217,0,0,239.8,238.7,0,0,0,0,0,0,0,0,""," has to end up with this data "NCHW\IQISW050R ","iNEQ Wireless BB Rou.& USB PrnServer ",218 in the same file it has line as follows, they have a common factor "zz, these lines need to be deleted "ZVPX\ARDX550 ","zz BenQ DX550 1200 Lum. XGA DLP AV-Box Thanks for any help that you can offer Cheers Trevor
