One does what one can
I am writing rules for transforming data in an upcoming migration. Unfortunately, the data has been entered "a little inconsistently". I may be good at techniques like grep, but one can only do what one can (and it is too much data to hand correct).
20/6/11 8389
20/7/09 4071
20/9 4532
20/9/11 9046
20/9/11 9046
1574
20/9/12 1576
20/9/12 1577
20/9/12 1577
20/9/12 1585
2021 - 27/01/2010
21/07/09 4080
21/07/09 4080
21/10 ($50.62)
21/4 3516
21/4/11 8030
21/5/12
21/6/11 3398
21/6/11 3398
21/8/13 3819
2186 - 15/1/13
2187 - 15/1/13
2192-15/1/13
2199 - 16/1/13
22/02/2010 #5182
22/02/2010 #5183
22/1/10 - 5006
22/11/12 - 1969
22/3/11 7746
20/6/11 8389
20/7/09 4071
20/9 4532
20/9/11 9046
20/9/11 9046
1574
20/9/12 1576
20/9/12 1577
20/9/12 1577
20/9/12 1585
2021 - 27/01/2010
21/07/09 4080
21/07/09 4080
21/10 ($50.62)
21/4 3516
21/4/11 8030
21/5/12
21/6/11 3398
21/6/11 3398
21/8/13 3819
2186 - 15/1/13
2187 - 15/1/13
2192-15/1/13
2199 - 16/1/13
22/02/2010 #5182
22/02/2010 #5183
22/1/10 - 5006
22/11/12 - 1969
22/3/11 7746