Find and replace

[eitancoh]

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]

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]

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]

Thank you Mark for your quick response.
I already found the replace command.

Thanks
Eitan