Find and replace YccyyMmm to previous month.

santosh_g · New User Joined: 14 Aug 2011 Posts: 24 Location: india

Hello,

I need to read input file and replace YyyyyMmm to previous month details i.e. Y2015M09.

Bill Woodger · Posted: Fri Oct 09, 2015 1:54 am

OK, but where are you going to get your date from to work out what the previous month is?

santosh_g · New User Joined: 14 Aug 2011 Posts: 24 Location: india

From current date (like DATE2 -1) and pull only yyyy and mm.

Bill Woodger · Posted: Fri Oct 09, 2015 2:34 am

And what are you going to do for testing? And what are you going to do for a re-run which is inconveniently "outside" the month which would give the "correct" result?

Bad idea.

If you're doing that, what problem do you have in achieving it? Why would you use FINDREP? The date is in a fixed position and is identifiable.

santosh_g · New User Joined: 14 Aug 2011 Posts: 24 Location: india

I tried something below for test runs but it didn't work out.

I was not using FINDREP but IFTHEN & OVERLAY.

Bill Woodger · Posted: Fri Oct 09, 2015 8:34 pm

In what way didn't it work? Can you show the sysout and any results, please?