PDA

View Full Version : Find and replace



eitancoh
02-14-2009, 11:15 PM
I have a text file with 400,000 records.
I need to replace a string with another string in each record.
What is the VBA command to do it?


Eitan

GTO
02-15-2009, 12:26 AM
Greetings Eitan,

I see that this is your first post, so let me be the first to say Welcome. I have been able to learn a lot here, and have met some really great folks who will go out of their way to help. I'm sure it will be the same for you :)

As to your question, I think we would need at minimum, a little sample data (can be "made-up" as long as it accurately reflects) that shows how the textfile is delimited.

Hope this helps,

Mark

eitancoh
02-15-2009, 01:07 AM
Greetings Eitan,

I see that this is your first post, so let me be the first to say Welcome. I have been able to learn a lot here, and have met some really great folks who will go out of their way to help. I'm sure it will be the same for you :)

As to your question, I think we would need at minimum, a little sample data (can be "made-up" as long as it accurately reflects) that shows how the textfile is delimited.

Hope this helps,

Mark

eitancoh
02-15-2009, 01:09 AM
Thank you Mark for your quick response.
I already found the replace command.

Thanks
Eitan