Shell Programming and Scripting

Hi,

I am new to unix and would greatly appreciate some help.

I have a file containing multiple colums containing different sets of data e.g.

File 1:

John Ireland 27_December_69
Mary England 13_March_55
Mike France 02_June_80

I am currently using the awk command to filter the first 2 columns to one file and the third column to another file e.g.

File 1:

John Ireland
Mary England
Mike France

File 2:

December
March
June


I then use the "paste" command to merge the data from both files so i get the following:

File 3:
John Ireland December
Mary England march
Mike France June


Is there a way to filter all the data to a single file and not to 2 seperate files. I am thinking of using the sed command but im not too sure.

If ive made anything unclear please reply and ill try to explain it better.

Thanks in advance.

Can be done using awk (only tested with GNU awk, might work with nawk too):

Code:

$ cat input.txt
John Ireland 27_December_69
Mary England 13_March_55
Mike France 02_June_80
$ awk -F '[ _]' '{print $1,$2,$4}' input.txt
John Ireland December
Mary England March
Mike France June

Hi,

Im using the code but it isnt working. Here is the data i am using and the code that i have typed;

Data in File:

Code:

Tue Nov 9 06:19:46 2010 00:14:53 R7_WRANMOMFJ_72.53
Tue Nov 9 06:30:56 2010 00:26:17 R7_BSIM_72.53

And here is the code i am using

Code:

cat $BUILD_TIMES
awk -F'[ _]' '{print $1,$2,$3,$5,$6,$8}' $BUILD_TIMES >> $FINAL_LIST

$BUILD_TIMES is the file i am referencing and $FINAL_LIST is the file i am putting the filtered data into.

Have i made a mistake with my syntax?

Moderator's Comments:

Please use [CODE][/CODE] tags

What exactly isn't working? What's the desired output and the real output? I'm getting

Code:

Tue Nov 06:19:46 2010 00:14:53 WRANMOMFJ
Tue Nov 06:30:56 2010 00:26:17 BSIM

with your current example.

Hi,

The actual input is

Code:

Tue Nov  9 06:19:46 2010    00:14:53 R7_WRANMOMFJ_72.53
Tue Nov  9 06:30:56 2010    00:26:17 R7_BSIM_72.53

and the desired output is

Code:

Tue Nov 9 2010 00:14:53 WRANMOMFJ
Tue Nov 9 2010 00:26:17 BSIM

When i run the awk command none of the input information is being filtered.

Any suggestions?

Thanks in advance

What version of awk are you using, on which OS? Are there perhaps tabulator characters in the log file (the parts where the space between the columns seem larger)?

I am currently using a program called "Putty" and my OS is vista. I am using the actual command "awk" and no other versions of it. Unfortunately ive only recently been introduced to this programming language.

How would i check for tabulator characters in the log file?