Using awk to "remove" unwanted text from CSV file

Question

Hi,

I have a CSV file like this:

SUPPORT 07/30/2008-10:59:54 Eastern Daylight Time
123     07/03/2009-08:56:42 Eastern Daylight Time
DC321   07/10/2009-20:16:56 Eastern Daylight Time

where the date is an entire column. how can i remove the entire "Eastern Daylight Time" part of the string with awk?

Answer 1

So you want only the 1st and 2nd column? If yes

awk '{print $1"\t"$2}' file.csv

Answer 2

Based on your comment in piotrsz's answer, this is how you could remove the EDT part:

awk '{gsub("Eastern Daylight Time", "");print}' file.csv

Answer 3

I don't know awk, but a sed version would be

sed "s/ Eastern Daylight Time//" file.csv

Answer 4

using just the shell

while read -r line
do
    case "$line" in
        *Eastern* )
            echo "${line%%Eastern*}"
            ;;
        *) echo "${line}"
    esac
done < "file"