Hi all,
I am looking for a code that can delete a range of rows when the find condition is met,that is the string " Configurable" is found and then all the rows including configurable and exluding the number "2018". the dataset is setup as csv within the first column file. the first range of rows is made up of 13 rows but on the next occurrence there are only 10 rows to be deleted. You will find a previous for the first 13 rows:
Configurable Alerts
Report ID:
Run Date:
Run Time:
HCR_SYS801
16/12/2018
22:30:49 UTC
Page
1 of
34
Enterprise Performance Mgt
78) PSFR data allocation by position (medium priority)
This alert gives the monthly data in PSFR to enable the allocation of expenses to partners.
2018,...,...
Thanks for the help much appreciated
I am looking for a code that can delete a range of rows when the find condition is met,that is the string " Configurable" is found and then all the rows including configurable and exluding the number "2018". the dataset is setup as csv within the first column file. the first range of rows is made up of 13 rows but on the next occurrence there are only 10 rows to be deleted. You will find a previous for the first 13 rows:
Configurable Alerts
Report ID:
Run Date:
Run Time:
HCR_SYS801
16/12/2018
22:30:49 UTC
Page
1 of
34
Enterprise Performance Mgt
78) PSFR data allocation by position (medium priority)
This alert gives the monthly data in PSFR to enable the allocation of expenses to partners.
2018,...,...
Thanks for the help much appreciated
Last edited:
