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