how to parce out part of a string and replace it with another stri

[Lisab]

Problem:
I have sereral files with simular names.
I would like to be able to replace part of the file name with a persons name

I want to replace the "Master" in the file name with [LastName]

Example:
November5MasterAssignmentFile1.xml --> November5JonesAssignmentFile1.xml
November12MasterAssignmentFile3.xml --> November5SmithAssignmentFile1.xml

Question:
Do I have to figure out an InString coding logic to accomplish this?
Is there a find and replace function or Code example I can use?

Thanks.

 

[Robert Morley]

All you need to do is:

strNewFileName = Replace(strOldFileName, "Master", [LastName])



Rob

 

[Lisab]

OH YES!
My mind was stuck on using the Mid, InStr, Right functions. I forgot about
the Replace function.
THANKS!

All you need to do is:

strNewFileName = Replace(strOldFileName, "Master", [LastName])



Rob

Problem:
I have sereral files with simular names.
I would like to be able to replace part of the file name with a persons name

I want to replace the "Master" in the file name with [LastName]

Example:
November5MasterAssignmentFile1.xml --> November5JonesAssignmentFile1.xml
November12MasterAssignmentFile3.xml --> November5SmithAssignmentFile1.xml

Question:
Do I have to figure out an InString coding logic to accomplish this?
Is there a find and replace function or Code example I can use?

Thanks.