Use sed or awk to fix date format

Question

I'm trying to convert a HTML containing a table to a .csv file using a `bash` script. So far I've acomplished the following steps: - Convert to Unix format (with `dos2unix`) - Remove all spaces and tabs (with `sed 's/[ ]//g'`) - Remove all the blank lines (with `sed ':a;N;$!ba;s/ //g'`) (this is necesary, because the HTML file has a blank line for each cell of the table... that's not my fault) - Remove the unnecesary `` and `` tags (with `sed 's///g'`) - Replace `` with ',' (with `sed 's/` with end-of-line (` `) characters (with `sed 's/

Accepted Answer

`Awk` can do this task pretty easily:

```
awk '
    BEGIN { FS = OFS = "," } 
    { split($3, date, /\//)
      $3 = date[3] "-" date[2] "-" date[1]
      print $0 
    }
' infile
```

It yields:

```
500,2,2007-09-13,30000.00,12,B-1
501,2,2007-09-15,14000.00,8,B-2
```

Use sed or awk to fix date format

Solution

Problem

Related problems