Regex Replace Function

[sneha_bhiwagade1]

Hi,

 REGEX_REPLACE Function to extract particular pattern from end of the string.

File path:  C:\Users\XYZ\2018\01\
PreviousMonth: 12

PreviousYear: 2017

Using REGEX_Replace(String, pattern, replace) function want to replace "01" month and year "2018"
with previous month "12" and previous year "2017"

Output path should be after using Regex_REPLACE

C:\Users\XYZ\2017\12\

Thanks

[jasperlch · Accepted solution]

Hi @sneha_bhiwagade1

A combination of Regex, DateTime and Formula tools will do the job:

[sneha_bhiwagade1]

Thank you.