UNIX for Advanced & Expert Users

Hi,

In a file I have data like...

-rw-r----- 1 ftpuser users 1036695 Jul 6 14:59 ./APRIL 2007/Ujjain/My Disc (D)/9565DW07.04B
-rw-r----- 1 ftpuser users 124080 Jul 6 14:59 ./APRIL 2007/Vadodara/vad_APRIL07/2082DW07.04B

The above data is extracted using "find . -name 4704DW07.03B -print > file1"

I want to generate output from the file like
1036695,9565DW07.04B
124080,2082DW07.04B

can anybody give me a command to do the same(without shell scripts).

Thanking you in advance,
Ronald.

Code:

awk '{print $5","basename ($9)}' datafile

Hi,

I'm getting following result

#cat file1 | awk '{print $5","basename($9)}'
awk: Function basename is not defined.
The input line number is 1.
The source line number is 1.


Regards,
Ronald.

Hi,

Also please note I have files like
-rw-r----- 1 ftpuser users 348738 Jul 6 14:38 ./APRIL 2007/patna/4976DW07.04B

i.e. between APRIL 2007, there is a space.

Regards,
Ronald.

Code:

$ cat file
-rw-r----- 1 ftpuser users 1036695 Jul 6 14:59 ./APRIL 2007/Ujjain/My Disc (D)/9565DW07.04B
-rw-r----- 1 ftpuser users 124080 Jul 6 14:59 ./APRIL 2007
$ awk -F"[ /]" ' { print $5 "," $NF } ' file
1036695,9565DW07.04B
124080,2082DW07.04B

Hi,

Thanks for your response. In some cases it works.

In the following case
[devofsa]:/db01/BOIDW_FEED_DIR/BOIDW_FTP_DIR/cibex#cat file2
-rw-r----- 1 ftpuser users 249384 Jul 6 14:38 ./APRIL 2007/patna/4975DW07.04B
-rw-r----- 1 ftpuser users 348738 Jul 6 14:38 ./APRIL 2007/patna/4976DW07.04B

[devofsa]:/db01/BOIDW_FEED_DIR/BOIDW_FTP_DIR/cibex#cat file2 | awk -F"[ /]" ' { print $5 "," $NF } '
ftpuser,4975DW07.04B
ftpuser,4976DW07.04B

Is there something wrong. in this case instead of user I want size!

Ronald.

I dont find any wrong here. Check whether that line contain non-printable characters