linux command for invalid month format replace

54 Views Asked by At

i have big data file in linux environment. eg:

xxxx,xxxxx,xxxx,xxx,xxx,x,xxx,xxxx,19222222,xxxxx,xxxx,xxx,xxxx
xxxx,xxxx,xxx,xx,xx,xx,xxx,xxxxx,19767714,xxxxxxxx,xxxxx,xxxx,xxx
xxxx,xxxxxx,xxxx,xx,xx,xxxxxx,xxxx,xxxxx,19551734,xxxxx,xxxx,xxx,xxxx

this kind of approximatetly 500000 records on file. i need invalid month and date birthdays replace to 00000000 format. please anyone can help to edit this file. Thanks!

Sed command for invalid date format to convert 00000000 format

0

There are 0 best solutions below