Skip to main content
S
Sunil Reddy
Known Participant
April 5, 2020
Question

Script required to update current month to next month

  • April 5, 2020
  • 2 replies
  • 611 views

Hello All,

I need script which should do multiple actions in one go...

 

1. Its recurring project every month I need to update month, lets say this month March to April and next month April to May. Everytime I should not replace AB month with CD month. It should be in loop, when it find March should replace with April and so on accordingly for next month.

 

2. In same document I need to replace Jan. 31 with Feb. 28 and next month Feb. 28 with March 31. Here for "January", "Februrary", "August", "September", "October", "November", "December", months will be in short form and for rest it will be full. Date would be last day of the month.

 

3. Update "13 months" with "14 months" and "14 months" with "15 months". This will continue till "23 months" with "24 months". Reason behind placing months after number is because if there is same number some where in document it will be replaced. In this instance luckily we have months followed by number, so it would be easy distinguish and replace.

 

4. Replace 01/20 with 02/20 and next month 02/20 with 03/20. 

 

5. Replace ABC1234 with ABCXXX. ABC will be any three alphabets and 1234 would be any 4 digits with same three alphabets following XXX or else would be with some digits.

 

Hope I made my requirement clear, could someone help me with script to do all these actions in one go. It could save my time. Thanks in Advance.

This topic has been closed for replies.

2 replies

Colin Flashman
Community Expert
Colin FlashmanCommunity Expert
Community Expert
April 6, 2020

With the script advice that is normally given in these forums, it is usually to do with a script that someone has made and is having difficulty with, rather than a bespoke request for a one-off script.

If the OP has a script of their own that they are having difficulty writing, we will try to provide assistance by looking at the code they have written and addressing any pain-points.

If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!
S
Sunil ReddyAuthor
Known Participant
April 6, 2020

Sorry!! I didn't realise that at first I have to try and then I should approach this community rather it sounds like an order. My appologies I should use this forum wisely to yield results. Thank you and hope I will find out myself and if there is any glitch then I will seek your support. 

 

#STAY SAFE

FRIdNGE
FRIdNGE
April 5, 2020

You forgot:

 

6. For free or not of course!

 

Personally, it won't be for free!  😉

 

(^/) The Jedi

M
Community Expert
Manan JoshiCommunity Expert
Community Expert
April 5, 2020

I second that Michel, according to me we can help in case someone is stuck at some point or if the script is a small/generic one. Posting a long list of requirements to get a tailored script seems like we are being asked to do someone's job or assignment.

-Manan
    S
    Sunil ReddyAuthor
    Known Participant
    April 6, 2020

    Sorry guys, I didn't realise that at first I have to try and then I should approach this community rather it sounds like an order. My appologies I should use this forum wisely to yield results. Thank you and hope I will find out myself and if there is any glitch then I will seek your support. 

     

    #STAY SAFE

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices