Manipulate full path

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.

Input

Output

Preparation

Accepted answers

alexnajm

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

All comments

alexnajm

Just sounds like two Replace functions in a row!

alexnajm

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

SharmaSachin

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?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703