Thanks Pete, > I don't have time to go through all your code (it's Saturday night!), > but are you aware of the MySQL TRIM() function? > > Once your records are loaded into irs_rawdata for the first time, you > could clear all the spaces in all the records with one line of SQL, no > need for a loop: > UPDATE irs_rawdata SET firstfield=TRIM( firstfield ), secondfield=TRIM( > secondfield )... etc
this is what I was looking for to ripe it out of the irs_rawdata table to began with, after the LOAD DATA LOCAL INFILE thing does what it needs then I will run the query you provide thanks a-lot!!!! Sincerely, Christopher
