UNIX and Linux Forums - Search Results

Showing results 1 to 4 of 4 Search took 0.00 seconds. Search: Posts Made By: anbu23

Forum: UNIX for Beginners Questions & Answers 05-10-2019

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

2,751

Posted By

$ cat testk3.csv "PERIOD_END_DATE"...

$ cat testk3.csv
"PERIOD_END_DATE" "PERIOD_END_DATE"
"17-FEB-19" "17-FEB-19"
"24-FEB-19" "24-FEB-19"
"24-FEB-19" "24-FEB-19"
$ awk -F, -v yr='"YEAR"' ' { $0=$0 OFS (NR == 1 ? yr : "20"...

Forum: UNIX for Beginners Questions & Answers 05-10-2019

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

2,751

Posted By

can you post sample data from testk3.csv?

can you post sample data from testk3.csv?

Forum: UNIX for Beginners Questions & Answers 05-10-2019

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

2,751

Posted By

Yes this will replace any year(If year is less...

Yes this will replace any year(If year is less than 2000 then prefix 19) and you can pass csv file to awk

Forum: UNIX for Beginners Questions & Answers 05-10-2019

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

2,751

Posted By

$ awk -F, -v yr='"YEAR"' ' { $0=$0 OFS (NR == 1 ?...

$ awk -F, -v yr='"YEAR"' ' { $0=$0 OFS (NR == 1 ? yr : "20" substr($0,length($0)-2,3)) } 1 ' OFS="," file
"abc","sdf","sdf","we","qe","fr","ty","hgf","er","jy","END_DATE","YEAR"...

Showing results 1 to 4 of 4