Hi - I have about 1200 variables that are in the format monYY_[indicator] which means they look something like this:

Code:
 Mar19_Cash_Cash_Outflows_Taxes
Jan19_Cash_Expenses_Business_Ins
Jan19_Cash_Cash_Outflows_Loan
Sep16_Cash_Cash_Inflows_Others
As you can see the number of underscore sign varies depending on the indicator. To run the reshape long command I need to rename them to the format [indicator]_mon_YY which will make them look like

Code:
 Cash_Cash_Outflows_Taxes_Mar_19
Cash_Expenses_Business_Ins_Jan_19
Cash_Cash_Outflows_Loan_Jan_19
Cash_Cash_Inflows_Others_Sep_16