I tried to write some code to parse the dates in this field. Only half of them were readable
Code
[root@ip-172-31-45-222 ~]# cat users.txt | cut -d'|' -f1,15 | grep -Ev "\|$" | while read nameDatePair; do echo $nameDatePair | cut -d'|' -f1 | tr '\n' '|' ; DATE=$(date --date="$(echo $nameDatePair | cut -d'|' -f2 | tr -d '.,' | sed 's/th//g' | sed 's/rd//g' | sed 's/st//g' | sed 's/nd//g')" 2>&1) ; echo $DATE ; done | wc -l
306
[root@ip-172-31-45-222 ~]# cat users.txt | cut -d'|' -f1,15 | grep -Ev "\|$" | while read nameDatePair; do echo $nameDatePair | cut -d'|' -f1 | tr '\n' '|' ; DATE=$(date --date="$(echo $nameDatePair | cut -d'|' -f2 | tr -d '.,' | sed 's/th//g' | sed 's/rd//g' | sed 's/st//g' | sed 's/nd//g')" 2>&1) ; echo $DATE ; done | grep invalid | wc -l
150
Among the various things to be found in this field:
date: invalid date ‘Suay March 9 2014’
date: invalid date ‘Moay April 21 2014’
date: invalid date ‘Satuay April 5 2014’
date: invalid date ‘Wednesdsay April 30 2014’
date: invalid date ‘Augu 8 2014’
date: invalid date ‘Satuay Augu 17 2013’
date: invalid date ‘Failure to Pass Cadet Te’
date: invalid date ‘2014/June/22’
In particular this Moay Suay Augu thing is very common. Whoever that was is a real asshat.
