modify specific character positions in a text file??? 1

[kskinne]

I have very large text files (over 200,000 rows) that I need to modify.

Each row in each file is 211 characters long, and I need to modify all of the rows by replacing the four characters in positions 41-44, with the characters '9999'. The four original characters vary from row to row and are never the same across rows.

Is there a way I can do this with vbscript and if so does anyone have a little code snippet they could share?

Or else does anyone know of a way I could do this without script? Any programs available that would automate this task?

 

[PHV]

Have a look at the FileSystemObject and the Mid function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kskinne]

Thank you - I'll look into that

Kevin