DosTips.com

Thanks Dave, that worked perfectly. I appreciate all your help.

After re-re-reading the post, I am not sure I explained the problem throughly. The text file is auto generated by our old system with the user already included in the file. I can't have it re-create the user unless I somehow strip it off the end. That's why I thought the easiest way was just to remo...

Thanks everyone. I really appreciate your help. The code seems to work except it added another user (and remove the space) at the end. How do I make it just replace the user? I only need the one username on the end. "ACC",250123,"John","Doe","MS","jdoe123...

I have a auto generated test file that had a username that combines first letter of first name with last name and part of an ID number. The problem I am having is if someone has a last name of two or more words it puts a space in that kills my automated upload. Here is part of the data: "ACC&qu...