AWK help to empty date column and prior colummn when date is less than current date in CSV file
I am new to AWK and have requirement.Please help me in solving below issue.
I have a CSV file(Comma delimited) with 8th,10th,12th columns as date columns. The dates are in YYYYMMDD format and the file is bit bigger in size (May be 3 to 4 mb).
The requirement is when the date value is less than current date , that date column and preceding column to date(the precding column will have amount) needs to become empty . support if 8th column date is less than current date then 8th and preceding 7th column should become blank. if 10th column date value is less than current date then 10 and 9th column value should become empty. if 12th column date is less than current date then 12th and preceding 11th
Re: AWK help to empty date column and prior colummn when date is less than current date in CSV file
Guru!! awesome... with nawk it is working.. when i was googling luckily i found your website posted question.. Thank you so much for the quality response..I will let u know in case if i get any issue in furthur testing...