Thanks for the help!

They all reside in the same dir. Exactly same format. I have created an .fmt to load one but now they just told me they need all the files loaded...

Allen_Cui, You are def correct. It works with the data that I provided. But here is the original and output data using the statement you sent me that I still...

Allen_Cui,

With that I than have results like the following:

270-05-76TH AVENUE

133-38-41ST RD #C01

and it should be

270-05 76TH AVENUE

133-38 41ST RD #C01

I wrote the following and it works for the case that I was talking about but it screws up my good ones, ex

14 -16 HEYWARD STREET

485 -BELLMORE AVENUE

Thanks for...

Is the sample on this website. Do you have a short cut to the article?

I guess I should have also said it was 100's of tables and columns so it would be tough to type out all of them

Thanks for the post! So if I am understanding you correctly, this pertains more to designing an application rather than to me running a cursor from QA massaging data?

Thanks for the post! So if I am understanding you correctly, this pertains more to designing an application rather than to me running a cursor from QA massaging data?