Manipulate full path

[SharmaSachin]

I have the full path of my input file as "D:ABC/FGH/inputs/April 2025 MTD.xlsx"

I want to manipulate it to generate an output at location "D:ABC/FGH/Outputs/April 2025 OTT.xlsx", so that it automatically gets selected in Output Data Tool.

Can someone please help me with the formula.

[alexnajm]

Just sounds like two Replace functions in a row!

[alexnajm · Accepted solution]

Replace(Replace([Full Path], “Inputs”, “Outputs”), “MTD”, “OTT”)

[SharmaSachin]

Hi 

What if I need it as OTs April 2025.

[alexnajm]

Then alter the replace statement! It'll just be different values to replace :)

Please try it out first, and come back with any questions - good luck!

[alexnajm]

@SharmaSachin what have you come up with?